I used an array entered vlookup do to that in my example.

=VLOOKUP(B1,F1:I4,{2,3,4},0)

Where B1 has the phone number to lookup.
Where F1:F4 is a list of the numbers to be looked up in the table array.
Where G1:I4 contain the address, city & state & zip Code in the table array.

Since you are returning three bits of address info you will need to select
three adjacent cells in a row where you want the info displayed, and while
the three cells are selected type in the vlookup formula above. It will
only appear in the first cell. Now hit CTRL + Shift + Enter, you will get
curly brackets around the formula and it should return the info of the 2nd,
3rd & 4th columns of the number in B1.

If you need to change the formula you will need to select all three of the
cells with the formulas, make your changes and hit CTRL + SHIFT + ENTER
again.

HTH
Regrds,
Howard
"Vangelo" wrote in message
...
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...?!