Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wild Cards with IF stmt | Excel Worksheet Functions | |||
wild cards? | Excel Discussion (Misc queries) | |||
wild cards in SUMIF | Excel Worksheet Functions | |||
Partial String Match & Wild Cards Using VLOOKUP | Excel Worksheet Functions | |||
If Statement Using Wild Cards | Excel Worksheet Functions |