How do you do a 3 to 4 way lookup in excel? Please refer to the attached file to see what I mean. I tried using Index() + Match() but nothing worked. Need your help.
Thanks.
How do you do a 3 to 4 way lookup in excel? Please refer to the attached file to see what I mean. I tried using Index() + Match() but nothing worked. Need your help.
Thanks.
Try Pivot table:
Or
you can use Sumproduct
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks