Modify search results based on text in another cell

[BDD2015]

Need a formula modified to give results based on the contents of another cell.
Please and thank you.

[Special-K]

in F3
=IF(E3="SPV","EOD","")
and copy down

[Special-K]

Oh you have a formula already in column F?
Then try this

in F3
=IF(E3="SPV","EOD",IF((SUM(IFERROR(SEARCH("EOD",$B3),0)))>0,"EOD",""))

[BDD2015]

Hi, Special_K

Thanks. Almost. Hope my sample wasn't wrong but I have applied your formula and there's a SNAFU.

[BDD2015]

Doesn't seem to work.

[Glenn Kennedy]

Why do you have ' before EOD in column F? Why is there a ' in some empt cells in F and not in others? They're not required...

=IF(E3="SPV",F3,"")&""

[Special-K]

All I've done is place IF E3 is SPV then EOD otherwise your formula?
If this is not the result you want then you need to define things more clearly.

[Glenn Kennedy]

If this is not the result you want then you need to define things more clearly.

I agree, too!!

[BDD2015]

Thanks, Glenn. This one does it. Think you saved me again. As for the ' ? Not sure but maybe because I pasted values instead of including the formulas?

[BDD2015]

Hi, Special-K and Glenn

Thought I was clear. I'll try to be clearer next time I post a question. Thanks to you both for your time.

[Glenn Kennedy]

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.