Hello,

I am using the formula below to search for text within a cell and return a specific value.

For example, if the text within a cell contains "1 lb bag" the value returned will be "lb". Is it possible to add more arguments and return different values based on what it finds? For example, if the cell contains "10 oz" it will return a value of "oz" instead of "lb"?

=IF(ISNUMBER(SEARCH("lb",J22)),"lb","")

Thank you in advance.