Previous Topic Next Topic

Formula help

Closed
KRICO14
Posts
1
Registration date
Thursday August 8, 2013
Status
Member
Last seen
August 8, 2013
 - Aug 8, 2013 at 01:33 PM
 Blocked Profile - Aug 8, 2013 at 02:15 PM
Hi,

I'm looking for a formula for the following scenario:

Worksheet 1
Cell A
129622

Worksheet 2
Cell A Cell B Cell C
129622 1,000 35

I need a formula that would return the value in Cell B (Worksheet 2) If cell C (worksheet 2) is less then or equal to 70 AND Cell A (both worksheets) match.

Does that make sense?

Thanks!

1 reply

Answer 1 / 1
Blocked Profile
Aug 8, 2013 at 02:15 PM
Hey try this....hopefully not doing your lab work for you!

=IF(AND(Sheet2!C1<=70,Sheet1!A1=Sheet2!A1),Sheet2!B1,FALSE)
0