I am trying to lookup a value. I've played around with VLookup, but just can't get it to do what I want. Hopefully, someone else is more knowledgeable about this than I am.
I have 3 columns, called AH, AO, and AP.
This is what I want to do (I hope this makes sense):
In column AO, I've entered the following formula:
The asterick ("*") is what I'm unsure of. Currently, I have "MAX(AH:AH)" there. It is returning the maximum number in column AH. But what I'm looking for is: For each cell in AO, I want to find the maximum value in AH in which AP has the same value.
So, with this example:
AH - AO - AP
1 - ? - 10
2 - ? - 10
3 - ? - 20
4 - ? - 20
5 - ? - 10
6 - ? - 30
7 - ? - 10
8 - ? - 20
9 - ? - 10
the value where the asterick is should be:
Thanks in advance for any help you can offer.