Thread: Formula Help Please
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carim[_2_] Carim[_2_] is offline
external usenet poster
  
Posts: 97
Default Formula Help Please
Hi Ken,

If I am not mistaken, you are looking for the last value <0 ...
Please adapt to your needs ...

=LOOKUP(2,1/(A1:L1<0),A1:L1)

HTH
Reply With QuoteReply With Quote