Hi, I am having a problem finding multiple text values in an "if" statement.
what I want to do is check for four different text strings in a cell for the logical test.
For example if the cell contains 'MDF','PB','PART', OR 'PLAT', I want to return "MACHINE1" otherwise return "MACHINE2".
I can't seem to get the FIND ISNUMBER and OR statements to work together.
Anyone have any ideas for me?
Thanks a bunch,