Are you sure your range is correct. i.e. the block of data that you want to
match too? Confirm that. Maybe you get n/a because the formula is not
looking at the entire range and thus doesn't pick up the match.

--
RONALD CROSS
"Erin Gertz" wrote in message
...
Thanks for the replies.

I tried the new formulas, with the empty quotes, but now I'm not getting
anything.

The PATIENTS worksheet is linked to an Access database through a query.
Could that have anything to do with it?

-Erin



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!