Match Formula

[Lizzy]

I'm having difficulty finding a formula that would match
cell B2 and D2 with cells that are in column F AND G. Now
the catch is that the data must match if its perpendicular
to each other, what I mean by this is that any cell in
column F and G lets say that cell F200 matches with B2 but
G200 does not match with D2, in this situation I would
like a result of NO to be returned. The same goes for if
any cell lets's say this time G45 matches with D2 but F45
does not match with B2 a result of NO will also be
returned. I need the formula to find an exact match row
wise. A result of YES will be returned if CELL F200
matches with cell B2 and G200 matches with D2. Hope I'm
making sense here.

 

[Lizzy]

Thank you so much.

-----Original Message-----
=IF(MATCH(B2,F2:F250,0)=MATCH(D2,G2:G250,0),"Yes", "No")
Should work, it finds where B2 is in F2:F250 and if the

number matches where D2 is in G2:G250 it returns Yes,
otherwise No.