Feb 26 2019 06:54 AM
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
Feb 26 2019 07:19 AM
Feb 26 2019 07:36 AM
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.
Feb 26 2019 06:12 PM
Feb 26 2019 11:49 PM
Hi Twifoo et al,
the equation does actually work, the thing that is limiting it is that the vlookup seems to have a limit of only the first 255 characters in the cell..... is this an actual thing? seems crazy to me! and super annoying that the error makes no mention that this is why......
anyone out there know if there is a way of overiding the 255 max limit?
Thanks.
Feb 27 2019 12:50 AM
Feb 27 2019 01:18 AM
dont suppose someone would have an example if this is my original equation>
=VLOOKUP("*"&A2&"*",'Data File'!A:B,2,FALSE)
thanks in advance...
Feb 27 2019 03:11 AM
Feb 27 2019 03:16 AM
Feb 27 2019 03:46 AM
Feb 27 2019 04:23 AM