make sure that the phone numbers and the cell you're pasting into are
formatted either as General, or preferably, Text.
Double check your VLOOKUP() formula - mine works fine. Some information
about the layout of your information would be helpful, along with seeing your
formula. Specifically it would help to know the columns used for the lookup
table and, as I said, your vlookup formula itself.

"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...?!