I have a spreadsheet that needs to be able to do a dynamic lookup with the
column to look in determined by the content of a cell. Basically, the cost of
an item is determined by where it came from. The same item may be sourced
several places. I have a list of items with columns for the various sources.
I have another tab in the same spreadsheet that will look up the cost based
on the source. But I won't know the source in advance.
A B C
1 Item# Source Cost
2 123 ABC vlookup(a2,"source list",ABC column,false)
3 345 DEF vlookup(a3,"source list",DEF column,false)

The Source in column B is the result of user input. The vlookup has to find
the column in the source tab based on that input. I've tried Index and Match
and some others but have had no success. Is this type of lookup even possible
in Excel?