I am attempting to search a second worksheet for and exact match using a
parameter in the first worksheet. I've solve the NA problem thanks to this
forum and MOST of the searches are turning up good data.

Unfortunately, I have a master list of hospitals in spreadsheet A and am
trying to mark which ones are transplant facilities from a list of these
hospitals off of spreadsheet B.

The formula finds the matches just fine but if a particular row is not found
in the subset list on B, it puts down the previous match until it finds the
next match and so on... I want anything that does not match to give a 0 or
blank (or similar). I would appreciate it if someone can help.

--
Doug S