how to combine if statement syntax for Search function with 2 possible values: "N" or "S"

[expansivesoundexperiments]

I currently have the following Excel If statements:


=IF(ISNUMBER(SEARCH("N",C37)),'Plan Code info '!C2,"")

=IF(ISNUMBER(SEARCH("S",C37)),'Plan Code info '!C3,"")

What is the correct syntax to combine these into one statement so that I can have logic to handle if there are values of "N" or "S" in the same cell?

I am using a reference to another sheet to populate the cell with specific values based on "S" or "N"

Thanks

 

[Joe4]

Welcome to the Board!

Can both "N" and "S" appear in the same cell?
If so, what do you want to happen in that case?

If only one of those two values can appear in the cell, and you just want one formula to handle either case, try nesting the IF statements, i.e.

[COLOR=#333333]=IF(ISNUMBER(SEARCH("N",C37)),'Plan Code info '!C2,[/COLOR][COLOR=#333333]IF(ISNUMBER(SEARCH("S",C37)),'Plan Code info '!C3,"")[/COLOR][COLOR=#333333])[/COLOR]

 

[expansivesoundexperiments]

Thanks only one value can appear per row

Thanks for the nesting logic!!!

 

[Joe4]

You are welcome.
Glad I was able to help!