Find a match in one column with other column and then replace it with a value

[cerebral]

Hello,

I am trying to match Phone numbers from Customers sheet to the records in Calls_Logs sheet. I want the name in Call Logs sheet to get updated according to matching phone number. I have close to 300000 records so it is impossible for me to do it manually. I tried using this code: =VLOOKUP(B3,Patient!A:C,2,FALSE) but it is not able to find out. Please some one help me out

Customers sheet
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Last[/TD]
[TD]First[/TD]
[TD]Other Phone[/TD]
[TD]Work Phone[/TD]
[TD]Home Phone[/TD]
[/TR]
[TR]
[TD]Mysterio[/TD]
[TD]Rey[/TD]
[TD]7864866789[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Steiner[/TD]
[TD]Scott[/TD]
[TD][TABLE="width: 88"]
<tbody>[TR]
[TD="width: 88, align: right"]9546329085[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD]3972598[/TD]
[/TR]
[TR]
[TD]Cold[/TD]
[TD]Stone[/TD]
[TD][TABLE="width: 88"]
<tbody>[TR]
[TD="width: 88, align: right"]6612628976[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD]78630585356[/TD]
[/TR]
[TR]
[TD]Lisa [/TD]
[TD]Ray[/TD]
[TD][TABLE="width: 88"]
<tbody>[TR]
[TD="width: 88, align: right"]3619455588[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="width: 78, align: right"]2249332353[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Call_Logs Sheet
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Phone Number[/TD]
[TD]Date[/TD]
[TD]Time[/TD]
[TD]Duration[/TD]
[TD]Name[/TD]
[/TR]
[TR]
[TD][TABLE="width: 104"]
<tbody>[TR]
[TD="width: 104, align: right"]3972598[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 112"]
<tbody>[TR]
[TD="width: 112"]Mon 05/11/2015[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64, align: right"]3:51 PM[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64, align: right"]0:02:51[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 104"]
<tbody>[TR]
[TD="width: 104, align: right"]6612628976[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 112"]
<tbody>[TR]
[TD="width: 112"]Fri 04/24/2015[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64, align: right"]4:27 PM[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64, align: right"]0:01:18[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 104"]
<tbody>[TR]
[TD="width: 104, align: right"]7864866789[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 112"]
<tbody>[TR]
[TD="width: 112"]Tue 03/31/2015[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64, align: right"]12:02 PM[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64, align: right"]0:03:53[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[cerebral]

No I am not using merged data. But the problem I think maybe is that all phone numbers are not in same format for eg. there is one phone number which is 31244432988 the other is in 7899800 and some other are in 1119007788. So basically they have different length.

 

[svendiamond]

That shouldn't matter as all we are doing is looking for a match for the number and returning the name that goes with it. This formula is working perfectly for me and I set up my sheets exactly the way you have them... maybe you could post a link to download the file and I can see what the problem is?

 

[cerebral]

That shouldn't matter as all we are doing is looking for a match for the number and returning the name that goes with it. This formula is working perfectly for me and I set up my sheets exactly the way you have them... maybe you could post a link to download the file and I can see what the problem is?

Hey thanks a lot, but still I am getting names for wrong phone numbers. I cannot upload data about contacts of patients. Maybe there is some problem in data, anyways thanks a lot for your help