Adding conditions to existing formula

[SOUTHLESS]

Hi Guys,

I have managed to muddle my way through to create a formula for a spreadsheet but i have now become stuck and would appreciate any help

The formula i have is =IF(ISNUMBER(SEARCH("Natalie Harper Laurence",B3)),"SWA",IF(ISNUMBER(SEARCH("Bernard Simpson",B3)),"SWA",IF(OR(L3="Y",M3="Y"),"CA",IF(J3="N","N","SA"))))

What i now need it to now add is if the cell contains "Natalie Harper Laurence" or "Bernard Simpson" and if either or both cells L3="Y" or M3="Y", i need it to put
"SWACHC"

Is this possible? Am i going around the houses in the first place?

I also need the formula to remain the same if "Natalie Harper Laurence" or "Bernard Simpson" are not in B3

I hope this makes sense and thank you in advance for any help

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

I will do it for you this time.Please read forum rules

[SOUTHLESS]

Thank you Pepe Le Mokko - I didnt really know what to call it, Thank you for changing it for me tho! Its my first time on a forum too

[zzzeddy]

Hi Southless

perhaps..
=IF(OR(B3="Natalie Harper-Laurence",B3="Bernard Simpson"),IF(OR(L3="Y",M3="Y"),"SWACHC","SWA"),IF(OR(L3="Y",M3="Y"),"CA",IF(J3="N","N","SA")))

..see attached

zeddy

[zzzeddy]

Hi Southless

..pardon me for adjusting the slant of your headings..it was easier for me to read this way.
..and I made column [AD] a little wider to allow for any "SWACHC" etc etc etc

zeddy

[SOUTHLESS]

zzzeddy you are a superstar!

Thank you so much!

Best

Southless

[6StringJazzer]

SOUTHLESS, as new member please take the time to review our rules. There aren't many, and they are all important. You have violated two of them already.

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread