[diggeryo]

I have Microsoft Excel 2007 with SP1 and all latest updates installed.

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:

=IF(AI2=1,PERSONAL.XLSB!RandInt(1,*), IF(AH2=AH1,AO1))

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:

9
9
8
8
9
6
9
8
9

Thanks in advance for any help you can offer.

mike.

[Advertisements]

Actually, the more I think about it, even if I got this formula to work, I don't think I would be able to use it because of some other reasons. Don't worry about it. Thanks anyway, though.

mike.

[diggeryo]

Actually, the more I think about it, even if I got this formula to work, I don't think I would be able to use it because of some other reasons. Don't worry about it. Thanks anyway, though.

mike.