So Im trying to create a conditional formula to depurate data into different columns. I've done it before and it has always worked but this time is just not working.
the formula is as follows:
=IFS(FIND("RBM",C2,1)>0,$F$3,FIND("HUM",C2,1)>0,$F$2,FIND("JKE",C2,1)>0,$F$4)
It works for RBM and HUM but when it gets to a JKE one, although if you evaluate FIND by pressing F9 and it comes out as true it still gives me #VALUE error.
Any ideas? I really need this to work. Ive included an extract of the spreadsheet
Bookmarks