I have a spreadsheet that lists a unique number (ID) and other unique numbers (Part) that are associated with the ID. Some of those Parts have an associated (Price) that I want to have returned to me. But I only want the formula to focus on a select few parts (Possible Parts) to get the Price. I'm admittedly green in Excel so I'm trying my best to explain what I need. In below example if I entered an ID of 124 into cell A2, I want the formula to search column D for 124. I then want it to find the Part in column E that also matches the available Possible Parts in column H. So if 124 was entered into A2, then B2 should result with $130,000.
If there is a better way to present this post, please let me know. Thanks.
Added attachment.....
Bookmarks