asked on

Excel formula based on specific entries in another column

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.

Thanks!
Andrea
EE-sample.xlsx

Tj a

Try this formula'

=IF(B2="####","",IF(B2="Yes","Mail",IF(B2="No","Hold","")))

Open in new window

Just put your desired link where I have ####
EE-sample.xlsx

ASKER CERTIFIED SOLUTION

Subodh Tiwari (Neeraj)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Subodh Tiwari (Neeraj)

@Takunda Jora

I don't think that this is the case. OP wants to show blank only if the B2 contains LINK to <four digits> i.e. #### in his example could be any number if I am not wrong.

Your formula will show the desired output but not because B2 meets the criteria but only because no criteria is met and it shows a blank. Evaluate your formula and you will know this.

Tj a

Ah, I see what you mean sktneer. In that case, your formula is what I'd go with.

Sorry about that. :)

Subodh Tiwari (Neeraj)

No need to say sorry. It happens with all of us later or sooner that we get confused by the description. No issues. Cool...

Andreamary

ASKER

Thanks very much, sktneer, for both your solution and feedback on the other formula suggested, as I wouldn't have realized it may not work...most helpful!

Cheers,
Andrea

Subodh Tiwari (Neeraj)

You're welcome Andrea! Glad I could help. :)
I only analyzed the other formula because it was returning the desired output while the formula was not correct and you could easily misguided because of the results returned.