Help with formula referencing a variable table range

Hi all,
Thoughts on what formula could accomplish the following?

I have two tables tableA and tableB

I want to do a vlookup in EITHER tableA OR tableB depending upon a cells value (value will be either A or B - the suffix of the table name)

How do I make excel recognize I am looking to reference a table name and not the cell value?

A1:B2 = TableA
A4:B5 = TableB

D3 = my lookup_value
D4 = "A"

The result I'm looking for is "=vlookup(D3,"Table"&D4,2,0) ....where "Table"&D4 will reference TableA

Thank you for your help!!

Hello and welcome to the forum.

Try this:

=VLOOKUP(D3,INDIRECT("Table"&D4),2,0)

Wow... I swear I tried INDIRECT, but kept getting #REF. I appreciate your quick response. That worked PERFECTLY!!!!!!

You're welcome. Thanks for the rep!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Originally Posted by Glenn Kennedy

Edit: who forgot to refresh after getting a coffee....

That'll teach you to get a coffee.