=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…wildcard-search

Any help?

Thanks,

Chris

**Important Notice**

We will be implementing some important changes during 25th and 26th May 2024 which may result in an outage period of the website. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

## Participate now!

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