Forum Discussion
Solved
Cross reference two columns
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 ...
=INDEX($C$2:$C$9,MATCH(B2,$D$2:$D$9,0))=A2You 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).
=INDEX($C$2:$C$9,MATCH(B2,$D$2:$D$9,0))=A2You 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).
- Very nice! Can you help with N/A cells then ? Is that because the value or name is not present in both columns?
=INDEX($C$2:$C$11,MATCH(B2,$D$2:$D$11,0))=A2In 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.
