I have a table of information that I need to be able to pull info out of. I am given a 3-4 digit number represented by the left-most column. So, for instance, row 3 shows 559. If the given input is 530, since it is greater than row 2's 459 but less than row 3's 559, the formula would look in row 3. Then I am given a number from 1-7. So the formula would need to look across row 3 until it comes to the column with that number in the top-most row and return the given value. I have provided two examples in my spreadsheet of the given variables and which value the formula would need to return.
Any help would be much appreciated!
Thanks!
Bookmarks