I need my vlookup() formula to look for a column by matching it instead of the basic vlookup() formula that has a static reference... column "1", "2", etc.
For example, if in the table lookup, the desired column with header of "asset" changes its column position, I want my vlookup() to be able to find that column instead of expecting it to always be col. "1".
What is the best way to accomplish this?...nest another hlookup() inside the vlookup() where the column reference goes? or does some kind of index match work better, or some other solution?
Keep in mind I have 6500 rows in both the lookup table array and the lookup value table, and 12 columns that will be used in lookup functions.