IS NUMBER SEARCH with two conditions

[Mr2017]

Hi

I'd like to write a formula which returns a value in a cell, depending on whether certain text is in two different cells in another tab.

The formula I've created is below:

It's meant to return the text in cell A3 from the "Scenarios" tab,

IF the words "As Is" are in cell A3 of the Scenarios tab AND
IF the word "Checked" in in cell C3 of the Scenarios tab.

Is there a way to do this? Thanks in advance.

=IF(and(ISNUMBER(SEARCH("As is",Scenarios!A3),ISNUMBER(SEARCH("Checked",Scenarios!c3),Scenarios!A3,""))))

Mr 2017.

 

[Jonmo1]

Looks like some misplaced )

=IF(and(ISNUMBER(SEARCH("As is",Scenarios!A3),ISNUMBER(SEARCH("Checked",Scenarios!c3),Scenarios!A3,""))))

Try
=IF(and(ISNUMBER(SEARCH("As is",Scenarios!A3)),ISNUMBER(SEARCH("Checked",Scenarios!c3))),Scenarios!A3,"")

 

[AlanY]

...........

 

[Mr2017]

Hi

Thanks for the prompt response.

I tried that, but it returns a blank instead of the text in cell A3 of the Scenarios tab?

 

[Jonmo1]

Then one of the two searches (or both) failed to find the strings.
I'd suggest using the formula evaluation tool to watch the formula execute each step.