Searching for data in two lists player a & player b the same as player b & player a

I have two lists of data one has all the pairings (column A) one has my pairings for the next week (column B).

I am using vlookup

Formula:

Please Login or Register  to view this content.

to compare the two lists which is working correctly as its showing the names that appear the way in the search list. However some pairings do not appear for example Player A & Player B but in my search list its Player B & Player A.

Is there a function / formula that will allow for both as I have tried a wild card to no avail.

Hi thank you for looking into this. Yes for the purpose of the post I have nulled out the data.

I have just tried to copy the code from above into column C but it comes up with:

#VALUE!
PlayerA & PlayerC
PlayerB & PlayerE
PlayerC & PlayerH
PlayerA & PlayerM
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!

Where the ones with #Value! are where they don't appear like with the Vlookup. For example PlayerB & PlayerA I'm searching but its PlayerA & PlayerB in the enquiry list.

Thanks again

No problem at all and I appreciate your time. However it's still showing some #value! for some in the spreadsheet attached. Thanks again

I'm not good at English.
If the problem has already been resolved, ignore it.

Formula:

Please Login or Register  to view this content.

Thank you very much this is working perfectly. However if the pairing doesn't exist it shows as #N/A is there anyway of showing a message such as FALSE or Already Paired?

Formula:

Please Login or Register  to view this content.

Thank you very much this is working perfectly

Do you have the solution in a file as happy to try again. Thank you for the warning is regards to the solution. Is there a way so it doesn't happen so it treats Jess and Jessica or Jen and Jennifer as different values.