vlookup assumes the value to match is in the leftmost column of the range.
This fits your criteria, so there is no reason to use Index and Match which
are equivalent, but don't have this restriction. Bernie has added an
additional test to see if there will be a match and thus suppress the #N/A
which is returned by default. You can prepend that test to the vlookup as
well if you want that.

--
Regards,
Tom Ogilvy

"derekc " wrote in message
...
im about to eat lunch, i will try both and get back to both of you as
soon as i can. thanks a bunch.


---
Message posted from http://www.ExcelForum.com/