Forum Discussion
Bill Hebner
May 07, 2018Copper Contributor
Using Excel lookup based on multiple criteria
Hi. I am attempting to create a table using the VLOOKUP function that compares a name in the left column and a category across the top row and returns the value in a separate table. Here's an exa...
Detlef_Lewin
May 07, 2018Silver Contributor
Bill,
a pivot table is the way to go.
Program in row area.
Type in column area.
Count in value area.