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