LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 65
Default Wild Cards in Vlookup

Hi! Experts

I have Phone number in 2 columns

Column A

Phone Number
9548878570/1204629955
9307584305
9690143335
9336884522
9368888865
9236644465
9250136689
9718856209
9278144529
1204629813
1204629955
1204211957
1204629893
9456366784

Column E

Phone Number
9336884522
9212544153/9368888865/9212572476
9236644465
9250136689
9718856209
9278144529
9810332270/1204629813
1204629955

Its only a Example Actually Data is Around 4000

You see in Both Columns there are Phone Numbers some has single Number but
some has Multiple Phone Numbers in a Single Cell.

For Ex.
In column A 1204629893
but in column E 9810332270/1204629893

When i Insert Vlookup or Index/Match Function it show #N/A

is there any way to using wild Card in Vlookup fuction. to match this Phone
Numbers

Thanks in Advance

Hardeep Kanwar
 
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
Wild Cards with IF stmt KarenF Excel Worksheet Functions 5 August 3rd 07 11:07 PM
wild cards? ferde Excel Discussion (Misc queries) 3 May 26th 07 06:28 AM
wild cards in SUMIF charles Excel Worksheet Functions 2 October 17th 06 10:29 PM
Partial String Match & Wild Cards Using VLOOKUP djDaemon Excel Worksheet Functions 0 March 9th 06 05:49 PM
If Statement Using Wild Cards Jasmine Excel Worksheet Functions 5 August 23rd 05 10:38 AM


All times are GMT +1. The time now is 01:35 PM.

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"