Lookups

J

Judd

I am tring to do a Lookup on a negative number. Not a
specific negative number, but the first time the number
becomes negative. I don't know to put this into the
Lookup formula as the Lookup Value.
 
A

Aladin Akyurek

=INDEX($A$1:$A$6,MATCH(1,INDEX(--($A$1:$A$6<0),0,1),0))

will give you the first negative number from A1:A6.
 
Top