Trying to match two values, one in each column, so if the combination of Cell A2 and Cell B2 MATCH anywhere in Column D and E.

I have two MATCH formulas that function perfectly...but I want to combine them using an "AND".... if possible.

=MATCH($A2, $D$1:$D$702, 0)

=MATCH($B2, $E$1:$E$702, 0)

Column "A" is Names

Column "B" is Numbers

Column "D" is a larger set of those same names, with duplicates

Column "E" is a larger set of those same numbers, with duplicates

Sorry cant post clean data via html genie, but here is a rough idea of what it looks like:

you will see "SMITH" and "14003" is the first match across the four columns

col A col B col D col E

names numbers names2 numbers2

SMITH 14003 SMITH 14026

SMITH 14002 SMITH 14001

SMITH 14001 SMITH 14027

SMITH 14004 Rogers 14029

JONES 14005 Rogers 14030

JONES 14006 Rogers 14018

JONES 14007 Rogers 14032

JONES 14008 JONES 14033

JONES 13009 JONES 14034

JONES 14010 JONES 14035

Rogers 14018 JONES 14036

Rogers 14012 JONES 14037

Rogers 14013 JONES 14038

Rogers 14014 SMITH 14039

Rogers 12015 SMITH 14003

I know this does not work, but it gives an idea of what I'm trying to accomplish:

=IF(AND(MATCH(($A2, $D$1:$D$702, 0)),MATCH($B2, $E$1:$E$702, 0)))

any help would be greatly appreciated!!