Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lookup function in Excel
When using the lookup function in Excel 2003, it would be extremely helpful
to have an error appear if the looked up item does not appear in the list. Example: If I have a small list of students in list A and I'm trying to look up the corresponding teacher in list B, it returns a teacher for every student in list A, even if that student is not in list B, and therefore, it is the wrong information. I would rather have it display an error message, so that I know that something is missing. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LOOKUP in Excel | Excel Worksheet Functions | |||
Will the Excel WEEKNUM function become ISO 8601 compliant? | Excel Worksheet Functions | |||
Does Excel 2000 have a 'datedif' function to calculate the number. | Excel Worksheet Functions | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Missing function in Excel 2003 | Excel Discussion (Misc queries) |