Forum Discussion
Bringing Multiple Columns Over from VLOOKUP Table
Howdy folks, Looking for advice on a VLOOKUP task and how you might handle it. In this example, I have a template that has fixed values in the rows (Department names), and two columns (Charges a...
Using an INDEX/MATCH formulation would be ideal when coping with the fact of not entering the index number manually. The thing is that I recommend that you use the same headers in the first table as in the PivotTable, unless you want to use another workaround.
See attached document with proposed solution. Enter the formula on B2 and you can then just drag it down and right.