View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hardeep kanwar Hardeep kanwar is offline
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