Vlookup on two different tabs

[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.

 

[Guest]

Perhaps a liitle more info .... is it a case if not found on tab1, look at
tab2?

 

[Pete_UK]

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

 

[Guest]

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.

 

[Pete_UK]

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