I checked for spaces - there were none that I could find. I tried typing in
the data from scratch - no good. Copying and pasting from those cells that
did work into the (identical) cells that didn't, caused the formula to return
the correct value. But I still have homerooms that have never given a correct
value. Even true, false, and 0 don't help in the fourth argument.

The range contains all the data - it's not very big - just 44 rows.

"L. Howard Kittle" wrote:

The usual suspects:

Leading or trailing spaces in the lookup column.
Does the named range contain ALL the data?
Use the 4th argument as False or 0

=VLOOKUP(E2,Range,2,0)

HTH
Regards,
Howard

"amberlodge" wrote in message
...
Excel 2000

Really simple data sheet: list of names with homerooms
Lookup table: list of homerooms with teachers. (named "Range")

=VLOOKUP(E2,Range,2)

Some of the cells return the correct name, others #N/A.

As far as I can tell they are all formatted exactly the same; I've tried
several different formatting options. The correct ones stay the same; the
no
data ones do not change either.

Any ideas?