I'll just go right to it.
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:
I think you need to Indirectly reference...
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: