Hello. I am working on a price comparison spreadsheet that requires updating annually. In the past I have done this manually, I was hoping I could automate this process, yet I am not sure how to start.

The spreadsheet I am working on has selected part #'s from 2 manufacturers. I have each manufacturers price sheet in Excel also. My challenge is how to get Excel to find the price cell for each of the selected part #'s, and insert the price into the corresponding price cell in the comparison spreadsheet.

Seems like it should possible, can anyone point me in the right direction?

Thanks