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
__________________________
|