I was able to import a list of contacts names and numbers, but now i wanna locate the correct name based from a call log of phone numbers to see if they are existing customers?
is this possible
thank you guys for all your help and support
If I understand well you have list of “Name” / “Phone number” and want then to find a name associated to a phone number?
I would use =VLOOKUP(D1;A1:B10;2;0) where column A contains phone numbers, B names and D1 is the phone number you want to find the associated name.
that worked perfect thank you very much much appreciation!!!