If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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) |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|