![]() |
Not quite the same lookup?
I have a column of data which contains location information in two separate
spreadsheets. Problem is that the text entries are not exactly the same in each case, so one spreadsheet might contain say 'London Acton', and the other might contain 'Acton', and in other cases they may be identical. Unfortunately the variations are not always this simple, so that rules out a text to columns solution. I want to be able to use one column as a lookup for the other such that if the first (London Acton) contains the second (Acton) in any part it will return a +ve/True condition and if not a -ve/False. Similar to - If String 1 contains String 2 return Yes, Else No. Where String 2 could be any one of 100 or so possibles. How can I do this? |
All times are GMT +1. The time now is 02:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com