lookup function help
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) |
lookup function help
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. |
lookup function help
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. "Dave" wrote: 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. |
All times are GMT +1. The time now is 09:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com