IF/VLOOKUP between multiple worksheets

J

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

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top