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
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.
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/f…okup-with-wildcard-search
Any help?
Thanks,
Chris
