It does the same in column B for the G2 value. * indicates that both conditions need to have a match to proceed. C2:C5 – Returns the value from C from rows 2 to 5 that matches both values. How does ...