Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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...?! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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...?! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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...?! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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...?! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using text from cell in a range lookup | Excel Discussion (Misc queries) | |||
use cell text in lookup function | Excel Worksheet Functions | |||
Referencing cell text in a lookup | Excel Discussion (Misc queries) | |||
Lookup certain text within a cell, PLEASE HELP! | Excel Worksheet Functions | |||
lookup a text cell and return text | Excel Discussion (Misc queries) |