Hi i have a complex task to match thousands of records for items with dimensions. I need to get result for the right thickness for the product.
Summary Information
- Item sizes, Material Type is provided
- Find the largest Dimension for each product
- Using the largest dimension find the matching material and give the result of the correct thickness
I have attach a sample file.
Thanks for the help in advance.
I think that you need to provide a better understanding of the criteria. You have assumed that we understand the dimension values of metals. Wrong!! We have expertise in Excel, but you need to explain the criteria that you are trying to match up with so that we can better show you how. The dimensions are meaningless to us unless you explain the relationships.
A mocked up solution explaining what you did manually to get the right answer will help us to understand how to solve your issue.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Hi Sorry, this is my first time seeking help this way. I have added in the result i wanted.
Last edited by AliGW; 08-18-2021 at 02:28 AM. Reason: PLEASE don't quote unnecessarily!
Try this:
=IFNA(INDEX($E$5:$E$44,MATCH(1,($B$5:$B$44=J5)*($D$5:$D$44>=I5),0)),"")
Last edited by AliGW; 08-18-2021 at 02:39 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Cell K5 array formula , Drag down
HTML Code:
It works and save plenty of error checking. Great and Thank you very much.Originally Posted by AliGW
This one also helpful. Thanks
If it is greater than 750 to 800, there is no reference, so it is necessary to return to blank, or to return to 0.8
Last edited by wk9128; 08-18-2021 at 05:56 AM.
This is error on my part. Sorry. But it will be great to add functionality to output Zero if error occur.
Cell K5 formula , Drag down
HTML Code:
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks