vlookup with variable column

[dperry]

I am trying to setup a vlookup where the column to return the result from is variable based on a pivot table update.

For example in the attached spreadsheet I have highlighted the vlookup formula used to pull data from the Data page, however based on product being added to the Data report the pre-cedes the one highlighted the current formula would return incorrect values

Any help would be appreciated

thanks

[BigBas]

Try the following formula and fill down:

Please Login or Register  to view this content.

When you change the lookup in cell B2, it will search for the column containing that part name.

[dperry]

Awesome! thanks a lot