VLOOKUP for multiple (14) sheets

**DP17** · 09-17-2012, 09:02 PM

I have several sheet numbers 101,102,103,104,105,106,100,112,113,115,117,122,123,125.

The below formula works fine for one of the sheets ...

Thanks for any help I can get.

=VLOOKUP($B37,'101'!B23:P154,11,FALSE)

**FDibbins** · 09-17-2012, 09:59 PM

to the best of my knowledge, vlookup() only works on 1 sheet at a time. to do what you want will probably require a vlookup specific to each sheet (unless some1 else knows a better way?)

**FDibbins** · 09-17-2012, 10:01 PM

i just noticed, this is a duplicate post

**mahmud9935** · 09-18-2012, 05:41 AM

Try this, just change sheet source,criteria and column index number, that works for multiple sheets. I guess you got my logic.

+IF(ISNA(VLOOKUP(A20,'0110-0112'!$1:$65536,4,FALSE)),IF(ISNA(VLOOKUP(A20,'0120'!$1:$65536,4,FALSE)),IF(ISNA(VLOOKUP(A20,'0130-0140'!$1:$65536,4,FALSE)),VLOOKUP(A20,'0150-0180'!$1:$65536,4,FALSE),VLOOKUP(A20,'0130-0140'!$1:$65536,4,FALSE)),VLOOKUP(A20,'0120'!$1:$65536,4,FALSE)),VLOOKUP(A20,'0110-0112'!$1:$65536,4,FALSE))