Forum Discussion
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...
Bill,
Do I understand correctly the combination of the program # and type is not repeated in your list?
Type "G" might be used by 14 out of 16 Programs, but type "I" might be used by 2. No program uses a type more than once.