Searching Grade Bins and Returning Product

[RickLocker]

Not even sure where to start.

The formula shown is supposed to read the various grades of material in P,Q,R,S column and then find which grade bin it sits in from the reference table and return the BIN type from Row 5. This used to work in an old version of the sheet I have but I'm trying to update it and it no longer works. I definitely don't understand the parts enough to rebuild the whole. Anyone see any glaring errors or a better way I can achieve this? As you can see the current returns highlighted in yellow are only WW and HG, cant seem to make it give me anything other than that...

 

[awoohaw]

Welcome to the forum.

can you post the data using xl2bb add in (link below)? Or paste as a table. You're asking the forum to recreate your scenario which is time consuming and can have errors in data entry.

Please help the forum help you.

 

[Kevin_Li]

It's best for you to fully describe the rules so that others can help you rewrite the formula. Sometimes it's difficult to see the result you need from an incorrect formula

 

[RickLocker]

Welcome to the forum.

can you post the data using xl2bb add in (link below)? Or paste as a table. You're asking the forum to recreate your scenario which is time consuming and can have errors in data entry.

Please help the forum help you.

Unfortunately I'm on a work machine currently and I don't have permissions to install any Add-ins. Ill try when I get home.

 

[RickLocker]

It's best for you to fully describe the rules so that others can help you rewrite the formula. Sometimes it's difficult to see the result you need from an incorrect formula

So for each of the elements, Fe, Si, Al2O3 and Mn there is a result grade. The Ore Bins are designed in a way that there is no overlap so if you check each one and discount the ones that don't fit inside each max min variable you will eventually be left with one. That will be the grade bin it falls in.

 

[awoohaw]

Unfortunately I'm on a work machine currently and I don't have permissions to install any Add-ins. Ill try when I get home.

you can post as a table.