Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search function
Hi,
I have a list of titles I need to find in another list. I know my original list isn't shwon the exact same way but need to find it none the less. E.g. in the original list it is shown as 'Eye', but in the list I am looking for it in it is shown as 'Eye, The'. A Vlookup won't work because they aren't the same. Is there a formula I can use to locate my target easily? I have several hundred I need to find. I also need to return a value to the right of the target column. Thanks Rick |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search function
RD wrote:
Hi, I have a list of titles I need to find in another list. I know my original list isn't shwon the exact same way but need to find it none the less. E.g. in the original list it is shown as 'Eye', but in the list I am looking for it in it is shown as 'Eye, The'. A Vlookup won't work because they aren't the same. Is there a formula I can use to locate my target easily? I have several hundred I need to find. I also need to return a value to the right of the target column. Thanks Rick Actually you might could use VLOOKUP, just throw some wildcards around the search term. This assumes your original list in sheet orig!A:B and a search term in another worksheet A1: =VLOOKUP("*"&A1&"*",orig!$A$1:$B$1000,1,FALSE) Increase the col_index_num parameter (given here as 1) to return other columns from orig. The big limitation of this sort of approach is you can only return at most one match, and it will be the first one. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search Function | Excel Worksheet Functions | |||
Search Function | Excel Worksheet Functions | |||
search function | New Users to Excel | |||
Search function | Excel Worksheet Functions | |||
Search function. | Excel Worksheet Functions |