| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Index / Lookup query
On Wed, 19 Jan 2005 08:47:58 -0500, "Tom Ogilvy"
wrote: =INDEX($A$5:$AK$5,1,SMALL(IF((ISNUMBER($G$7:$AK$7 )*($G$7:$AK$7<0)),COLUMN($ G$7:$AK$7)),1)) Thanks again Tom. Perfect answer as usual. Rgds __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index, match, multiple IFs query | Excel Worksheet Functions | |||
| if, Isnumber, Match, &index query | Excel Discussion (Misc queries) | |||
| index and match query | Excel Worksheet Functions | |||
| INDEX AND MATCH QUERY ? | Excel Worksheet Functions | |||
| Help please! Lookup/Index query. | Excel Discussion (Misc queries) | |||
Threaded Mode
