I've read a few threads trying to find my answer but they were too abstract for me to understand.
Lets say on one spreadsheet I have my actual sales:
Customer Part Sales
Cisco A $W
Nortel A $X
Cisco B $Y
Nortel B $Z
I have a second spread sheet with my forecasted sales
Customer Part Sales
Cisco A $??
What I want to do is have a vlookup of the actual sales figure of Part A. The problem is, I have two criteria. It not only has to be the sales for Part A, it has to be only Cisco sales for part A when multiple customers are buying this same part.
So, how do I do a two criteria Vlookup?
-John
Bookmarks