Lookups

  • Thread starter Thread starter Judd
  • Start date Start date
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.
 
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
 
=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.
 
Back
Top