Prev: What does " mean in excel
Next: Entering Values and Updating Next Empty Cell in a Range
From: midnight_t on 5 Mar 2010 23:36
Hi there,

Here's the situation. I have a bunch of game prices in cells I8:I15. In
cells B8:B15 are the names of these games. I have a cell that gives me the
highest price [=MAX(I8:I15)] but instead of showing the price, I want it to
show the name of the game. But I don't want to have to enter the name myself,
I want Excel to do this automatically so if the prices change it can update
itself. Is this possible? [Or does it even make any sense? ;)]

Thanks in advance for any help (:

Cheers,
Jake.
From: T. Valko on 6 Mar 2010 00:18
Try this...

=INDEX(B8:B15,MATCH(MAX(I8:I15),I8:I15,0))

Note that if more than one game has the max price the formula will find the
name of the first instance of max.

Game1...10
Game2...15
Game3...12
Game4...15

The formula will return Game2.

--
Biff
Microsoft Excel MVP


"midnight_t" <midnightt(a)discussions.microsoft.com> wrote in message
news:77E20111-0FA5-492C-B5A6-06CE88393A56(a)microsoft.com...
> Hi there,
>
> Here's the situation. I have a bunch of game prices in cells I8:I15. In
> cells B8:B15 are the names of these games. I have a cell that gives me the
> highest price [=MAX(I8:I15)] but instead of showing the price, I want it
> to
> show the name of the game. But I don't want to have to enter the name
> myself,
> I want Excel to do this automatically so if the prices change it can
> update
> itself. Is this possible? [Or does it even make any sense? ;)]
>
> Thanks in advance for any help (:
>
> Cheers,
> Jake.


 | 
Pages: 1
Prev: What does " mean in excel
Next: Entering Values and Updating Next Empty Cell in a Range