I need the formula that provides the result in a cell to change/be selected from a table of values, based in the input in two other cells. For instance, based on the size input into cell B23 (1,2,3 etc)and the Unit input into cell B26 (GPM, MGD, etc), the result in B49 is calculated using values in a table consisting of 3 columns and 10 rows starting at K22.
Solved by A. L. in 11 mins