Hello, I am trying to find a formula that will do this I have rows that has 9k100tkh0gs 100, 9k100tkh0gs 250, and 9k100tkh0gs 500, I want a formula that will look only at the 100, 250 or 500 in a cell. for example I have 20 rows with 9k100 100, 9k100 250 9k100 500, 9k150 100, 9k150 250, 9k150 500,and so on.
I want the formula to put "OK" next to the cells that has 100 or 250 and "NON STOCK" by the ones that has 500
any help will be appreciated.
Thanks
Bookmarks