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,




Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies