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

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.
 
T

T. Valko

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I validate an entire colume instead of a cell 1
HOW DO I GET A CELL TO RETURN A NEIGHBORING CELL'S VALUE 6
selecting the penultimate cell from a column of data 3
Excel Lookup 1
Data entered from list automatically enters number in another cell 4
How do I add to figures already in a cell? 4
function how to! 6
Excel won't update/calculate a single cell in a workbook 2

Top