I'll just go right to it.
=VLOOKUP("REF",LookUpTable"NAME",1,TRUE)
The formula works if the "NAME" is static, like "LookUpTableSets", but the issue is that I need to have the "Sets" part refer to another cell, which is 5 columns to the left. I have 30 or so different lookuptables.
I have hundreds of cells that need this formula, so dragging this down and or across would save days or work.
I have tried several different ways, but so far I get #NA or #NAME as the result. The closest I think I have gotten is to do a WILDCARD MATCH, but I can't figure out what goes where.
That was on this post:
https://www.ozgrid.com/forum/forum/he…wildcardsearch
Any help?
Thanks,
Chris
VLOOKUP and reference another cell for the LookupTable"NAME"



I think you need to Indirectly reference...
e.g.
=VLOOKUP("REF",INDIRECT("LookUpTable"&A2),1,TRUE)
Where A2 contains the "Sets" word, and as you copy down it reference what's in A3, A4, etc...

Thanks for the quick reply!
Using that method gives me #REF!
So, I took out the quotes from LookUpTable, and Then I got #NAME! error. 
What exactly is the naming convention of your tables?
What exactly is located in your reference cells?Maybe post a sample workbook?

Well, After looking closer at the actual solution you posted, I realized I was missing a part of the table name...
The name of the tables always start with "LookUpTableDrwSlide" then the Specific table name. I made that adjustment and it works wonderfully!
Always the small details...
Thank you so very much!
The actual formula is now:
=VLOOKUP(Drawer_Max_Length_Calc,INDIRECT("LookUpTableDrwSlide"&AD52),1,TRUE)Thanks again!
Chris 

Awesome :rock:
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!