Warren Keogh
New Member
Hi
I have a sample file attached. I want to a cell containing text. If the text is there then it returns an account code number, (there could be multiple searches). This is the formula I have used and it only works for the first text search ("CAR") what am I doing wrong??
=IF(SEARCH("*"&"CAR"&"*",A2),208,IF(SEARCH("*"&"BIKE"&"*",A2),206))
Thanks
WK
I have a sample file attached. I want to a cell containing text. If the text is there then it returns an account code number, (there could be multiple searches). This is the formula I have used and it only works for the first text search ("CAR") what am I doing wrong??
=IF(SEARCH("*"&"CAR"&"*",A2),208,IF(SEARCH("*"&"BIKE"&"*",A2),206))
Thanks
WK