On Tue, 25 Aug 2009 15:17:30 -0500, Dave Peterson wrote:

You can only use the entire column in xl2007.

So use a range that's big enough for your data:

=IF(LOOKUP(10^10,B1:B111)-LOOKUP(2,1/(C1:C111="oil change"),B1:B111)5000,
"need oil change","")



salgud wrote:

On Tue, 25 Aug 2009 10:27:02 -0700, Teethless mama wrote:

Assume Date in column A, Mileage in column B, and Status in column C

In E2: =IF(LOOKUP(10^10,B:B)-LOOKUP(2,1/(C:C="oil change"),B:B)5000,"need
oil change","")

Thanks for your reply. I'm getting a #NUM error on the term (C:C="oil
change"). Any ideas?

If you have the time, can you explain the LOOKUP(2,1/(C:C="oil change")
part of the equation? What is the reciprocal of the (C:C="oil change")?

Thanks, Dave. Works great!