Posted to microsoft.public.excel.worksheet.functions

Thomas Mandeville Thomas Mandeville is offline

external usenet poster

Posts: 1

Lookup Value in Table

Excel 2007

I have data that looks like the following

A B C
Row 1 INTC MSFT IBM
Row 2 $1500 $2400 $1850

I need to write a formula that finds the maximum value in row 2, and
returns the corresponding value in row 1. The MAX() function will
return $2400, but I can't figure out how to get my formula to return
"MSFT" which is what I really need.

Any help will be greatly appreciated!

--Tom

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Table lookup	Richard[_2_]	Excel Worksheet Functions	3	October 30th 08 08:55 AM
Lookup data in a variable table & retrieve data from a pivot table	Shawna	Excel Worksheet Functions	3	October 10th 08 11:11 PM
lookup a value in a table	saintsalive	Excel Discussion (Misc queries)	4	September 7th 07 01:58 PM
lookup table	Brian	Excel Discussion (Misc queries)	2	December 2nd 05 06:15 PM
Pivot table doing a lookup without using the lookup function?	NGASGELI	Excel Discussion (Misc queries)	0	August 2nd 05 05:08 AM

All times are GMT +1. The time now is 12:38 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us