On Thu, 17 Feb 2005 07:43:06 -0800, "Feldy"
wrote:

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.



If you want an error message in the lookup formula, add an option
after the number of columns. IE: =3Dvlookup(cellref,lookup
range,columns,FALSE). If the cellref isn't in the lookup range, the
results of the formula will be '#N/A".

Hope that is what you wanted.

Don S