Excel formula if a value matches a value in a range of cells

Hello,

I would like to get the following result: if Column A cells exact match Column B cells then in Column D return the corresponding value in Column C.

Meaning, if origin matches destination, return the location corresponding to destination.

Screenshot 2024-01-02 231636.png

Test this on D2

Formula:

=IF(A2=B2,C2,"")

This would work if it was row by row 1 to 1 relationship. But Column B values are randomized and not in order so I need Column A to search through all of Column B and copy the corresponding values column c value when there is a match.

Originally Posted by DJunqueira

Test this on D2

Formula:

=IF(A2=B2,C2,"")

This would work if it was row by row 1 to 1 relationship. But Column B values are randomized and not in order so I need Column A to search through all of Column B and copy the corresponding values column c value when there is a match.

Another guess in D2.

=XLOOKUP(FILTER(A2:A100,A2:A100<>""),B2:B100,C2:C100,"",0)

Originally Posted by windknife

Another guess in D2.

=XLOOKUP(FILTER(A2:A100,A2:A100<>""),B2:B100,C2:C100,"",0)

I tried it but got a #SPILL! error

You must clean all expected results in column D.

Formula:

=xlookup(a2:a11,$b$2:$b$11,$c$2:$c$11,"",0)

Originally Posted by DJunqueira

Formula:

=xlookup(a2:a11,$b$2:$b$11,$c$2:$c$11,"",0)

Dear DJunqueira - this worked! Thank you, and really appreciate you taking the time to build out the spreadsheet I should have done. Many blessings!

Thank you for the feedback.

Have a nice new year.