Hi All,
I'm trying to do this formul but is not working.
=IF(ISNUMBER(SEARCH("*LR 10*";A2));"M01";B2)
so in column A2 I have the long desription of the loan and I want to find the ones that contain "LR 10", and if this is true to put in cell C2 "M01" otherwise the value that is in cell B2...