Jan 16 2019 05:14 AM - edited Jan 16 2019 06:10 AM
Hi,
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,
Quinn