Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Excel formula help


  • Please log in to reply

#1
diggeryo

diggeryo

    Member

  • Member
  • PipPipPip
  • 343 posts
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.
  • 0

Advertisements


#2
diggeryo

diggeryo

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 343 posts
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.
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP