Finding a matching partnumber out of a horizontal list

Quinn Fung-A-Wing
Occasional Contributor



I would like some help with a formula that will let me search the parts in column B and D through J to find the corresponding value in the Alternative partnumber Tab, column A. Once there's a match in column A on the alternatives partnumber tab, it should find the corresponding Alternative partnumber in column C on the alternative partnumber tab and place that partnumber in column K on the data tab, and the corresponding price, type and model in columns L through N.


note: some of the parts in columns D through J on the Data tab are present in column B. These duplicates may have to be eliminated first.


Pls let me know if there are any questions,