Hey thanks, Dave S. Mailed in for the raise and I'm positive the
check-is-in-the-mail!!! (Discounted for misspelling the word "you" as
"yoy")

Thanks for the feedback.
Howard


"Dave The Favorite" wrote in
message ...
Works Perfectly! Put yourself in for a raise, Howard....and I'll approve
it.
Dave Stevens :-)

"L. Howard Kittle" wrote:

In addition to the other solutions, if you don't want the #N/A to show in
your return cell, give this a try, adjust ranges to suit your sheet, as
well
as what you want to be returned. In these cases its "nothing", "the
value
zero" or "anything yoy want".

=IF(ISNA(VLOOKUP(C1,$A$1:$B$4,2,FALSE)),"",VLOOKUP (C1,$A$1:$B$4,2,FALSE))

=IF(ISNA(VLOOKUP(C1,$A$1:$B$4,2,FALSE)),"0",VLOOKU P(C1,$A$1:$B$4,2,FALSE))

=IF(ISNA(VLOOKUP(C1,$A$1:$B$4,2,FALSE)),"Any thing you want
here",VLOOKUP(C1,$A$1:$B$4,2,FALSE))

HTH
Regards,
Howard