VLOOKUP Issue

**purplehaze1988** · 02-15-2010, 09:54 AM

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.

**Richard Buttrey** · 02-15-2010, 10:05 AM

Hi,

Almost impossible to advise without seeing the formula in context. Can you upload the workbook, or at least a cut down sample from it, anonymised if necessary.

Rgds

**purplehaze1988** · 02-15-2010, 10:43 AM

Thanks for replying.

It's very tricky for me to anonymise the data, so I will ask around internally first.

I'll probably end up crawling back here though :D

**darkyam** · 02-15-2010, 11:52 AM

Perhaps seeing just the formula is enough...

**Lithium78** · 02-18-2010, 11:06 PM

You'll probably need an

=IF(ISNA(vlookup(value,range,column,false)),"",vlookup(value,range,column,false))

That will return a blank instead of N/A when it can't find a direct match.

**martindwilson** · 02-19-2010, 06:22 PM

test the cells = each other
find two that should match say a1 on sheet1 and a70 on sheet 2
then put
on sheet 1 somewhere
=a1=sheet2!a70 and see if you get true or false

**forurajeev22** · 02-25-2010, 12:19 PM

If both cells contain same values then only you will get answer othewise you will get #N/A only. You have same values in both cells but you didn't get the result, then you have any spaces at the end of the words.If you haven't solved your problem yet I can clarify your doubt, if you attached it,