2 column to 2 column lookup and match

[wherdzik]

Hi I am looking for a 2 column to 2 column lookup and match. I created a formula in column R of the Pay Mngmt Tab but it is using a helper column. What I would like is to use the Employee No and Provider column and look it up against the pay name sheet with the same column combinations. I would like to accomplish this without a 'helper' column.

Thank you.

[davsth]

is the check just to see if they are present
=COUNTIFS('Pay Name Check'!A:A,'Pay Mgmt Summary'!C5,'Pay Name Check'!B:B,'Pay Mgmt Summary'!P5)

will return the number of times the combination is on the other sheet