Dec 13 2022 02:58 AM - edited Dec 13 2022 02:58 AM
Hello
I'm trying to figure out how to first cross reference two text string columns and then filter it so i only have duplicates and then cross reference the duplicates in relation to the vendor number they are given to see if the two vendors have been asigned the same vendor number e.g.
D.Number | D.Name | P.Number | P.Name |
1001 | Keith | 1234 | Peter |
1234 | Peter | 1001 | Keith |
1002 | Ralph | 1005 | Ralph |
I Hope this make sense, I have about 1400 lines that I need to sort xD
Dec 13 2022 03:16 AM
Solution=INDEX($C$2:$C$9,MATCH(B2,$D$2:$D$9,0))=A2
You can try this formula. It returns TRUE or FALSE (WAHR or FALSCH in german Excel) if the D.Number and P.Number are the same for the name in column B (D.Name).
Dec 13 2022 04:28 AM
Dec 13 2022 06:57 AM
=INDEX($C$2:$C$11,MATCH(B2,$D$2:$D$11,0))=A2
In the example the NA (NV in german Excel) occurs because the D.Name doesn't occur in the P.Name column.
=IFERROR(INDEX($C$2:$C$11,MATCH(B2,$D$2:$D$11,0))=A2,"")
You can wrap the formula into IFERROR if you want to return e.g. an empty instead of NV.
Dec 13 2022 03:16 AM
Solution=INDEX($C$2:$C$9,MATCH(B2,$D$2:$D$9,0))=A2
You can try this formula. It returns TRUE or FALSE (WAHR or FALSCH in german Excel) if the D.Number and P.Number are the same for the name in column B (D.Name).