I would like a formula for Column C, based on Column B data, as follows:
If Column B = LINK to #### (ie., LINK to 4566), return a blank cell in Column C
If Column B = Yes, return the word 'Mail' in Column C
If Column B = No, return the word 'Hold' in Column C
I have attached a sample spreadsheet as well, illustrating what I am looking for.