Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I Auto insert an "X" in a cell by just ONE left click???? | Excel Discussion (Misc queries) | |||
what happened to the insert = at the left of the formula bar? | New Users to Excel | |||
can excel insert rown based on variable data in a cell? | Excel Worksheet Functions | |||
Set a 2D arrray data into a range, given the top-left cell | Excel Discussion (Misc queries) | |||
Splitting Data in a cell, left or right of a separator. | Excel Discussion (Misc queries) |