lookup a text cell
 

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

lookup a text cell
 

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

lookup a text cell
 

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

lookup a text cell
 

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