• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help need for formula

Hi need a formula to check the item status.

Item
Item status
G157970103
generic
4501969498
Normal

Missing

Missing
4501949034
Normal

If the item is blank then missing if starts with G then generic and anything else then normal
 
Assuming first Item Code is in A3; =if(left(A3,1)="G", "Generic",if(A3="","Missing","Normal"))

I would suggest having Item code in one column and the status in the other though so you can just drag down the formula instead of a lot of copying and pasting which would be neccessary when the status is below each item
 
Back
Top