My Values sheet has a column that needs to be populated with values obtained from the Tables sheet (same workbook) that has multiple tables. I named each table as _89MS and _89MNS. My HLOOKUP needs to be able to determine which table (multiple tables in one worksheet) to extract values from. I actually have several tables, but have included 2 for this example. I do other calcs that end with a value that indicates what table to use. It's a static table of values. For instance a value of 339 aligns with table 89MS, and 364 aligns with 89MNS. So if my calculation renders 339, then I need to use table 89MS. My conundrum is how do I assign the value of 339 to the named array of _89MS, and hence use that named array in my HLOOKUP formula.
I attached a simple Excel as an example. Note, that I am using Excel 2016. Will need to update my profile. Thanks
Bookmarks