Home » Forums » Open Source Learning Center » Question and Answer

Need help with Excel formula

Submitted by fpiret on 9 May, 2013 - 15:12

I am struggling with a formula I am currently trying to create.

Worksheet 1 = S1
Worksheet 2 = S2
Cell 1 on sheet 1 = S1C1
Cell 2 on sheet 1 = S1C2
Cell 3 on sheet 1 = S1C3
Cell 4 on sheet 2 = S2C4
Column 1 on sheet 2 = S2Co1

My formulat got to look if S1C1 exist in S2Co1, and if S1C2=WELL or S1C3=TOO, it got to return me the content of the S2C4

I have tried with IF AND and Vlookup, and got totally lost.

Can anybody explain me how I am supposed to do this?

Thanks a lot.

‹ Track and display multiple changes by different users as comment Employee Schedule not plotting properly - chart type / data series not correct ›
»

need help with excel formula

Submitted by pcrobinson on 10 May, 2013 - 19:16.

This formula should work. I have broken it up to first test for the MATCH in s2co1, and then check whether the OR condition is satisfied. I found it easier than trying to do it all in one.

=IF(ISERROR(MATCH(A1,test,0)),"not satisfied",IF(OR(B1="well",C1="too"),Sheet2!D1,"not satisfied"))

The relevant range on sheet 2 I have named "test"
Regards

»