Hi,

First, the form of the address you want to bring back has nothing to do with
where VLOOKUP works or not.
Second, the form of the phone number IS important, suppose the formula you
are using looks like this

=VLOOKUP(A1,M1:N25,2,FALSE)

Then the phone number in A1 must match the phone number in column M. If the
pasted phone number is Text and the column M phone number is numeric then it
won't work. They must both be text or both be numbers or else you need to
modify your formula to handle the discrepency.

Show us a sample of the lookup value (A1 above) and the lookup table.
Remember, just because two cell look alike doesn't make them identical.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Vangelo" wrote:

I want to paste a phone number in one cell and see the home address related
to this phone number in another cell.
I try with vlookup but it seems like the combination of , or . or - in the
address cell does not let me vlookup..

Can some one come up with a solution please...?!