Hi

sounds like you need to use the VLOOKUP function with the fourth parameter
set to 0 or FALSE, if you omit the fourth parameter it defaults to TRUE or
in other words - an "approximate match" instead of an "exact match." (which
is what the 0 or False will give you). In this case if the item is not
found a #NA error will be returned.

Cheers
JulieD

"Feldy" wrote in message
...
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.