Hello - I have something I cannot figure out. I would appreciate any help you can give... A spreadsheet is attached.
The number in cell M21 falls into one of the ranges from C4 to C15.
A matrix number needs to be printed in each cell from N21 to N30.
The selection of the number to be printed in column N (under Matrix Assignment) depends on the range it is next to in array A4:C15.
For example (as shown), the correct number for cell N21 is 122 because 0.2626 falls between 0.24 - 0.2699, and Matrix 122 corresponds to that range.
Hopefully I explained this so you can understand what I really need. Thanks.
Bookmarks