Find matching data, copy data in adjacent cell and paste in new column

Hello,
Looking for a formula that will look at a part number in column A1 and find a matching part number in column D1 thru D55, then return the part number in column C next to the match it found in column D and enter the part number from column C into cell B1.
I tried using =IF(ISERROR(MATCH(A1,$D$1:$D$55,0)) but this is as far as I could get.
Hope this is not too confusing.
Is this doable?
Thanks for any help.
Bikeman.

Try

=IFERROR(INDEX($C$1:$C$55,MATCH(A1,$D$1:$D$55,0)),"")

Thanks Jonmo1,
This did not work, I entered the formula into Cell B1 but it did not return any result. I did check and the part number in A1 is also found in column D.

Also thanks for your quick response.

Bikeman

Can you post a sample book?
Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Jonmo1,

Sorry I have tried to attach spread sheet but for some reason it will not work. I have done this many times, not sure what is going on. I even tried taking a picture (png.file) and uploading it but still no luck.

Not sure where to go from here.

Bikeman

Jacc, Thanks for the info. Very helpful.

I can only think of 2 reasons that formula would not return a result

1. If the value of A1 does not exist in $D$1:$D$55
Check for exact spelling, and extra spaces like "Hello" vs " Hello" vs "Hello "

2. The value of A1 DOES exist in $D$1:$D$55, but the corresponding value from Column C is an error like #N/A

I copied A1 part number to the same part number in column D and it worked!
I must of had some format issue as I did not see any space issue, I need to figure out what was different between the two.

Thanks again your help.

Bikeman

You're welcome