lookup function help

[alberson]

I am having a problem with the formula below. I have a chart of
certifications listed by date which are due annually. I have a column
dedicated to list the next date a certification must be renewed. No problems
with that, but the next column is to list the title of the certification that
is due on that date. Only on 3 of over 100 rows do i have a problem. I keep
getting the "#N/A" result. These certifications cannot be listed in order by
date. Any recommendations?

=LOOKUP(MINA(O17:AB17),O17:AB17,O1:AB1)

 

[Dave]

Hi Alberson,
Usually when you have just a few errors as you describe, it's because some
of the data is formatted as text when it should be numbers, or text that has
leading or trailing spaces, which are hard to spot...
Regards - Dave.

 

[alberson]

Tried that. No dice. All the data is listed in date format (01-Mar-09), but
it still doesn't work on those same three rows. I thought it was because
they weren't in order numerically, but other rows don't have any issues with
that.