Match product descriptions from 1 list of skus to a separate list of the same skus

[coreyvictoria]

I have a sheet with 3 columns.

Column A contains a list of product skus.
Column B contains another list of procut skus.
Column C contains product descriptions that match the skus in column B.

I need to maintain the sku order of column A, but match the corresponding descriptions from column C. As you can see (image attached), Column A and B do not match up perfectly. My desired end result would be column A (as is) with an adjacent column of descriptions from column C. What formula can I use to achieve this?

 

[Fluff]

Hi & welcome to MrExcel.
Which column do you want the result in?

 

[coreyvictoria]

Hi & welcome to MrExcel.
Which column do you want the result in?

Thank you. I'd like the result in Column D.

 

[Fluff]

Ok, how about in D2 copied down

=INDEX($C$2:$C$100,MATCH(A2,$B$2:$B$100,0))

 

[coreyvictoria]

Works perfect! Thank you so much!!

 

[Fluff]

You're welcome & thanks for the feedback.