Forum Discussion
Excel formula question
Hi, I have two columns of client names. If the same client appears in both coloms I want to add the Id of the client in colomn A to colomn C. How can I do this? Thank you!
In C2:
=XLOOKUP(D2, $B$2:$B$1000, $A$2:$A$1000, "")
or if you have an older version of Excel:
=IFERROR(INDEX($A$2:$A$1000, MATCH(D2, $B$2:$B$1000, 0)), "")
Fill down.