Vlookup on two different tabs
 

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.

Vlookup on two different tabs
 

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

"Ayse" wrote:

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.

Vlookup on two different tabs
 

Something like this:

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

Hope this helps.

Pete

On Jul 12, 5:38 pm, Ayse wrote:
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.

Vlookup on two different tabs
 

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.

"Toppers" wrote:

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

"Ayse" wrote:

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.

Vlookup on two different tabs
 

Oops, missed a bracket after the second sheet2 - should be:

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

Hope this helps.

Pete

On Jul 12, 5:47 pm, Pete_UK wrote:
Something like this:

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

Hope this helps.

Pete

On Jul 12, 5:38 pm, Ayse wrote:



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.- Hide quoted text -

- Show quoted text -