Forum Discussion
Bobby_Todorova
Jul 19, 2022Copper Contributor
lookup formula
Hello, I need some help. in first column Salon beauty Sofia Salon Varna Salov nail and pedicure Plovdiv in Second column Sofia Varna Plovdiv I want to match word from second column...
- Jul 19, 2022
=IF(ISNUMBER(MATCH(TRUE,ISNUMBER(SEARCH($B$1:$B$3,A1)),0)),TRIM(SUBSTITUTE(A1,INDEX($B$1:$B$3,MATCH(TRUE,ISNUMBER(SEARCH($B$1:$B$3,A1)),0)),"")),A1)
You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021. The formula can be copied down and range $B$1:$B$3 can be adapted as required.
OliverScheurich
Jul 19, 2022Gold Contributor
=IF(ISNUMBER(MATCH(TRUE,ISNUMBER(SEARCH($B$1:$B$3,A1)),0)),TRIM(SUBSTITUTE(A1,INDEX($B$1:$B$3,MATCH(TRUE,ISNUMBER(SEARCH($B$1:$B$3,A1)),0)),"")),A1)
You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021. The formula can be copied down and range $B$1:$B$3 can be adapted as required.
Bobby_Todorova
Jul 20, 2022Copper Contributor
Thanks so so so much!!!!