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