VLOOKUP and reference another cell for the LookupTable"NAME"

    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

    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...

    Where there is a will there are many ways. Finding one that works for you is the challenge!

    What exactly is the naming convention of your tables?
    What exactly is located in your reference cells?


    Maybe post a sample workbook?

    Where there is a will there are many ways. Finding one that works for you is the challenge!

    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

Participate now!

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

Register Yourself Login