LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using text from cell in a range lookup abergman Excel Discussion (Misc queries) 2 January 5th 09 09:03 PM
use cell text in lookup function rsmith Excel Worksheet Functions 3 May 21st 08 06:37 PM
Referencing cell text in a lookup Rich Excel Discussion (Misc queries) 4 September 20th 06 08:29 PM
Lookup certain text within a cell, PLEASE HELP! [email protected] Excel Worksheet Functions 3 August 9th 06 03:54 PM
lookup a text cell and return text Cristi R Excel Discussion (Misc queries) 4 August 2nd 06 02:41 PM


All times are GMT +1. The time now is 08:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"