Lookups

[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.

 

[Matt]

If you set the Range_lookup to TRUE and the lookup_value
to 0 provided there is no 0 in your lookup array, Vlookup
will return the largest value that is less than or equal
to lookup_value, ie the first negative number.

Matt

 

[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.