Forum Discussion
Searching and matching phone numbers in a list against spreadsheet data.
Hi, I have some data (3000 lines) which contains a lot of text within cells and within that data are phone numbers and post codes etc. On another tab I have a long list of phone numbers, about 150 or so. and on another tab I have post codes. abnout 50...
What I want/need to do is to identify the cells in the data that have a match against the list of phone numbers and then to id the cells that match against the post code information.
I thought Vlookup would do it, but that seems to only look for exact match, but I am only wanting to ID the cells with the matching numbers in it so it wont give me a result. Have tried SEARCH function also but not making any progress.
any help is gratefully accepted! Cheers
- You can use VLOOKUP or INDEX-MATCH with the wildcard character (*) in the lookup_value argument.
Hi Twifoo, thanks for the comment, I have attempted it now with wild card, but it gives error in equation, does this look like it should work?
=VLOOKUP(*A2*,'Data File'!A:B,2,)thanks.
- Your formula should return your expected result unless your lookup_value is not available, wherein it returns #N/A error.
