Vlookup on two different tabs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to look up a value in two different tabs. Does anyone know how
to do this? The VLOOKUP function allows me to look up only one tab.
 
Something like this:

=IF(ISNA(vlookup(on_sheet1)),IF(ISNA(vlookup(on_sheet2)),"not
present",vlookup(on_sheet2),vlookup(on_sheet1))

Hope this helps.

Pete
 
Yes that is the case, where I keep open issues in one tab with an ID, and put
them in a different tab when the issue is closed with the same ID.
 
Oops, missed a bracket after the second sheet2 - should be:

=IF(ISNA(vlookup(on_sheet1)),IF(ISNA(vlookup(on_sheet2)),"not
present",vlookup(on_sheet2)),vlookup(on_sheet1))

Hope this helps.

Pete
 
Back
Top