Multiple Values to be put in an Equation

[gauravwalia]

Hi Could someone Please Help on this
$F$2 Needs to Match B:B and G2 Needs to Match A:A and $H$1 Needs to Match C:C. If all there Match then Answer is Yes else No.
Where F2 Can change


[TABLE="width: 874"]
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD][/TD]
[TD]F [/TD]
[TD] G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Date[/TD]
[TD]Cab No[/TD]
[TD]Status[/TD]
[TD][/TD]
[TD]Cab No to Enter[/TD]
[TD] [/TD]
[TD]PU[/TD]
[TD]DP[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD="align: right"]1-Oct-17[/TD]
[TD="align: right"]2345[/TD]
[TD]PU[/TD]
[TD][/TD]
[TD]2345[/TD]
[TD="align: right"]1-Oct-17[/TD]
[TD]Yes[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD="align: right"]1-Oct-17[/TD]
[TD="align: right"]1234[/TD]
[TD]PU[/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: right"]2-Oct-17[/TD]
[TD]No[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD="align: right"]1-Oct-17[/TD]
[TD="align: right"]3314[/TD]
[TD]DP[/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: right"]3-Oct-17[/TD]
[TD]No[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD="align: right"]2-Oct-17[/TD]
[TD="align: right"]3315[/TD]
[TD]PU[/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: right"]4-Oct-17[/TD]
[TD]No[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD="align: right"]3-Oct-17[/TD]
[TD="align: right"]2345[/TD]
[TD]DP[/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: right"]5-Oct-17[/TD]
[TD]No[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: right"]6-Oct-17[/TD]
[TD]No[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: right"]7-Oct-17[/TD]
[TD]No[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: right"]8-Oct-17[/TD]
[TD]No[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: right"]9-Oct-17[/TD]
[TD]No[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: right"]10-Oct-17[/TD]
[TD]No[/TD]
[TD]No[/TD]
[/TR]
</tbody>[/TABLE]

 

[Rick Rothstein]

Put this formula in cell H2 and copy it across to cell I2, then copy them both down to your last data row in Column G...

=IF(COUNTIFS($B$2:$B$6,$G2,$C$2:$C$6,$F$2,$D$2:$D$6,H$1),"Yes","No")

Note: The red highlighted data range corresponds to your data in Columns B, C and D and will need to be changed if you expand or shrink the data there.

 

[gauravwalia]

Thank you so much