Forum Discussion
Solved
Return single value from array of data from different worksheet using IF
Hi All, Hope everyone is fine and fruity. This is my first post here, I've tried to find an answer in the forum posts but to no success. Hopefully someone can give me some advice or point me in the ...
If to return Yes if any of the cells in Sheet2!E3:E50 is less than correspondent cell in sheet2!f3:f50, when
=IF(SUMPRODUCT(--(Sheet2!$E$3:$E$50<Sheet2!$F$3:$F$50)),"Yes","")
If to return Yes if any of the cells in Sheet2!E3:E50 is less than correspondent cell in sheet2!f3:f50, when
=IF(SUMPRODUCT(--(Sheet2!$E$3:$E$50<Sheet2!$F$3:$F$50)),"Yes","")
Thank you Sergei, you are a diamond.
NonEventHorizon , you are welcome