How do I tell Excel to insert data from a cell 4 to the left?
 

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.

How do I tell Excel to insert data from a cell 4 to the left?
 

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" wrote in message
...
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.