Forum Discussion
Working with a large data set...
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, ...
=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.