Vlookup using two values

Originally Posted by 63falcondude

Try

=IF(AND(A1=A3,A2=A4),"Match",NA())

That's where my assumption was going as well... Just not sure if that is the intention - But I agree this is what it sounds like

Originally Posted by bodled

I'm messing this up sorry, so looking at the graphic above in this case I would need A2 & B2 to return an "OK" if they can find identical cells in rows D & E thats more like it

See post #7.

The OP sample is indicating that they want to be able to rule out matches from both sets. Left to right and right to left... but they will NOT be in the same row if you look at the sample data in which "OK" is indicated when they are not aligned... To which again I say utilize what I provided and you should be good to go.

Do they need to be in the same order? Can you create a small sample book... I think I am about to make some assumptions that may lead to something that you are not actually doing.

Just provide a small sample set as if it was in your data (Mock data) but in the same layout. Copy that and create a second sheet showing what you would like it to do through the formula... meaning if this is all in columns ABCD and you want E to display N/A when they do not match that will help us provide a solid solution.

Thanks

Okay, So you are saying they are not always paired side by side...
C2 Put this and drag down

=IF(Countifs($D:$D,$A2,$E:$E,$B2)>0,"ok","N/A")

F2 Put this and drag down

=IF(Countifs($A:$A,$D2,$B:$B,$E2)>0,"ok","N/A")

Should just about do that

Correct - Try the solutions I provided previously, they should do the trick. You just need to enter them in the specific cells I listed and then drag the formulas down.