I used vlookup a lot but I've always been using it with single criteria. but now, I need it for multiple criteria. For example, column A2 - A5 = A and B2- B5 is P2, P3, P4. I want to be able to lookup for A and A5.
Please refer to the file and picture below.
i want to be able to lookup C,P2 and return 55 for billy.
thanks