Hi everyone

I was wondering if anyone could help with the following problem:

I currently have 2 databases of site addresses. One is outdated, but lists all site telephone numbers and e-mail addresses. The new one doesn't.

Somebody has created a VLOOKUP formular for me so that the new database can find the e-mail and phone numbers of any sites that are also in the old one.

The unique identifier we're using is street name. However, if there is no exact match, it provides the "closest" match, which I don't want.

I tried to change the "TRUE" bit to "FALSE" in the formular to get exact matches, but then I get #N/A for every cell. Might be because I simply clicked & dragged the formular to all the other cells.

If anyone can help me get an exact match, and prevent somewhere in China being given a "possible match" of a phone number in Slovakia, that would be great.