Forum Discussion
Solved
IF: how to replace "true" with content from a specific cell?
hello dear Community, I have a column B with a list of industries (doctor, hairdresser, garage, etc.) and I have a column A with keywords (Super Car Garage, Clear Cut, doctor Martin, etc. ), for...
=IFERROR(INDEX($B$1:$B$3,MATCH(TRUE,ISNUMBER(SEARCH($B$1:$B$3,A1)),0)),"")You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
=IFERROR(INDEX($B$1:$B$3,MATCH(TRUE,ISNUMBER(SEARCH($B$1:$B$3,A1)),0)),"")You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
Dear OliverScheurichmany many thanks for your very quick solution 🙂 it is working perfectly and spares me many hours searching for the right formula (I wouldn't have found this though). You made my day ! Thanks
Philippe
Assuming there are no blank cells in column B
