Home

Finding a matching partnumber out of a horizontal list

Quinn Fung-A-Wing
Occasional Contributor

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

 

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies