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

  • Thread starter Thread starter midnight_t
  • Start date Start date
M

midnight_t

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.
 
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.
 
Back
Top