How to find a string in a row and return true or false

Hello,

I need help with excel, any help would be appreciated.

This might be a simple solution, but I am not very good at excel.

I am looking for the word "ERROR" in a row and in 1 specific cell V44, if found I want the cell containing this formula to show "ERROR". IF word "ERROR" is not found in either cell V44 or row H40:U40, i want it to return the result of this: V40+V42-V43.

So far what I have and it doesn't work:

=IF((OR(V44="ERROR",HLOOKUP("ERROR",H40:U40, 50, FALSE))),"ERROR",V40+V42-V43)


Thanks in advance!

Greg

Hi,
I think following formula can help You to solve the problem:

=IF((OR(V44="ERROR",iserror(HLOOKUP("ERROR",H40:U40, 50, FALSE)=FALSE)),"ERROR",V40+V42-V43)

Try

=IF(OR(V44="Error",COUNTIF(H40:U40,"Error")),"Error",V40+V42+F43)

Originally Posted by Jonmo1

Try

=IF(OR(V44="Error",COUNTIF(H40:U40,"Error")),"Error",V40+V42+F43)

this one worked! thank you for your help

You're welcome.