LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I Auto insert an "X" in a cell by just ONE left click???? Mac 5430 Excel Discussion (Misc queries) 3 April 14th 08 12:52 AM
what happened to the insert = at the left of the formula bar? vtj New Users to Excel 1 September 7th 07 08:56 PM
can excel insert rown based on variable data in a cell? SSBG Excel Worksheet Functions 1 August 6th 06 01:30 PM
Set a 2D arrray data into a range, given the top-left cell Tom Chau Excel Discussion (Misc queries) 2 June 29th 06 06:53 AM
Splitting Data in a cell, left or right of a separator. ross Excel Discussion (Misc queries) 1 August 12th 05 02:27 AM


All times are GMT +1. The time now is 03:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"