Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions

vezerid

Posts: n/a

Conditional Lookup?

K,
is it the most negative number you are seeking? And it has to be
negative? If so, this formula will produce the correct header:
=INDEX(A1:D1,MATCH(MIN(IF(A2:D2<0, A2:D2, 1)), A2:D2, 0))
It must be array entered, i.e. Shift+Ctrl+Enter

HTH
Kostis Vezerides

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
Conditional Lookup	AlanM	Excel Discussion (Misc queries)	3	November 18th 05 04:55 PM
Conditional Formatting - Lookup Range	murphyz	Excel Discussion (Misc queries)	8	August 24th 05 03:55 PM
Conditional Lookup Functions	Rlmccants	Excel Worksheet Functions	4	August 11th 05 10:14 PM
Conditional Lookup on Multiple Criteria	TBarker	Excel Worksheet Functions	1	June 22nd 05 12:28 AM
conditional lookup	JimVarney01	Excel Worksheet Functions	0	May 24th 05 11:40 PM

All times are GMT +1. The time now is 02:06 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us