Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to combine an IF Function with a lookup function to determine | Excel Worksheet Functions | |||
Need help on LOOKUP function..please | New Users to Excel | |||
lookup function | Excel Worksheet Functions | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
Lookup Function | Excel Worksheet Functions |