IF/VLOOKUP between multiple worksheets

[Joe]

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",vlookup(B!,A:H,6,FALSE), etc.

Thank you in advance for your assistance.

Joe Stephens

 

[T. Valko]

=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)