it is necessary to compare two excel columns and then return a third colume duplicate value

June 2, 2022 / 1 minute of reading

Here you go. Remember to use control + shift + enter instead of enter.

=INDEX(C:C,MATCH(F3&G3,A:A&B:B,0))

enter image description here

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top