Vlookup areas?

[Sam]

Hello All,

I use Vlook up all the time but i only ever look up from one tab to another
tab, does anyone know if its possible to look up something in all tabs at the
same time?

For example i want to see if items column A on spreedsheet one are repeated
in column A, B or C in spreedsheet two...

Thanks.

 

[Pete_UK]

One general approach:

=IF(ISNA(vlookup_1),IF(ISNA(vlookup_2),IF(ISNA(vlookup_3),"not
present",vlookup_3),vlookup_2),vlookup_1)

where vlookup_1 is looking at table_1, vlookup_2 is looking at table_2
etc, and table_1 and table_2 are not necessarily in the same sheet.

In your particular case, though, you can use MATCH:

=IF(ISNA(MATCH(A2,Sheet2!A:A,0)),"","A") & IF(ISNA(MATCH(A2,Sheet2!B:B,
0)),"","B") & IF(ISNA(MATCH(A2,Sheet2!C:C,0),"","C")

Will return A, B or C if A2 in Sheet1 is found in any of those columns
in Sheet2.

Hope this helps.

Pete

 

[Sam]

Hi Howard,

Your right it looks very intimidating, so i have lots of tabs and will add
to them everymonth, for example my tabs are actually number 8269, 8268, 8267
etcso i f i create a sheet with this formula in it (i guess i can actually
keep in in the same workbook) what formula would i be looking to start with??
sorry blonde moment..

Thanks,
Sam.