Jan 31 2023 11:33 AM
I'm trying to work with something that looks like this. There are Areas from A to G and they all have different pricing based on weight. For example, if over 500 but under 1000, and in area D, then it would be 121.10, but if in area G, then it would be 136.00.
I'm not sure how I would calculate a formula where I could put an IF for 7 different areas as well as 7 different weight classes and have it spit out 49 different numbers.
Would really appreciate the help!!
Jan 31 2023 11:50 AM
=INDEX($K$3:$Q$9,MATCH($D2,$J$3:$J$9,0),MATCH($G2,$K$2:$Q$2,1))
You can set up a reference table as shown in the screenshot.