IF/VLOOKUP between multiple worksheets
 

Hello -

I am trying to identify an alternative for the following IF/VLOOKUP formula
for 13 individual letters with matching Sheets!:
=IF(A3="A",vlookup(A!,A:H,6,FALSE),IF(A3="B",vlook up(B!,A:H,6,FALSE), etc.

Thank you in advance for your assistance.

Joe Stephens

IF/VLOOKUP between multiple worksheets
 

=IF(A3="A",vlookup(A!,A:H,6,FALSE),

You left out the actual lookup value.

Try it like this...

A1 being the lookup value.
A3 being the sheet name.

=VLOOKUP(A1,INDIRECT("'"&A3&"'!A:H"),6,0)

--
Biff
Microsoft Excel MVP


"Joe" wrote in message
...
Hello -

I am trying to identify an alternative for the following IF/VLOOKUP
formula
for 13 individual letters with matching Sheets!:
=IF(A3="A",vlookup(A!,A:H,6,FALSE),IF(A3="B",vlook up(B!,A:H,6,FALSE), etc.

Thank you in advance for your assistance.

Joe Stephens