View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Richard Buttrey Richard Buttrey is offline
external usenet poster
 
Posts: 296
Default 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
__________________________