Two things.
1) You are missing a condition, what should the cell be if it does not match your criteria as stated?
2) you do realize that a cell can contain either a formula or a value but not both.
igold
=IF(ISNUMBER(SEARCH("LBS",G112)),"",IF(ISNUMBER(SEARCH("LB",G112)),"",IF(AND(OR(ISNUMBER(SEARCH("LBS",G112)),(ISNUMBER(SEARCH("LB",G112)))),ISNUMBER(SEARCH("OZ",G112))),LEFT(G112,LOOKUP(2^15,SEARCH({"X","-"},G112))-1),F112)))
Above is my formula the problem is it is not working,
What i'm trying to accomplish is if the cell contains only the word "lbs" or ONLY the word "lb" then it should be blank if it contains the word lbs or the word lb AND IN THE SAME CELL IT ALSO HAS THE word "oz" OR "OZ" then ,LEFT(G112,LOOKUP(2^15,SEARCH({"X","-"},G112))-1