I'm trying return a value in a range from the row that matches two separate conditions.
I tried to use this statement: =IF(AND(B2:B7="Tuesday",C2:C7="Shift 2",D2:D7,"")
Looking to return the value 11 in D6
A B C D
Row 2 Monday Shift 1 8
Row 3 Monday Shift 2 9
Row 4 Monday Shift 3 7
Row 5 Tuesday Shift 1 8
Row 6 Tuesday Shift 2 11
Row 7 Tuesday Shift 3 7
Am I close???
Bookmarks