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