If any cell in A1:A10 equals a value in D1:D10, then in B1:B10, I want to return the value left of the matching value in column D (which would be the value in column C).

For example:
If A1 =Part Description1
and D1 also =Part Description1
then left go left -1 to C1 which =Part#1
and return the value from C1 to B1=Part#1

The reason I need this to happen in a range is because not all of these matching values are lined up in the same rows.

Thank you!