I am trying to write an Excel formula in a cell in my main worksheet that has a value that needs to be compared to a table in another worksheet that has a low (column A) and high value (column B) (this table has 17 rows that list low and high values and the corresponding value). Depending on which row the value from the first worksheet falls between, the corresponding value in column C of the second worksheet should be returned. The values are all in percent format (99.80% for example).
Worksheet 1 Value in column A is:
99.50
Worksheet 2 Value Table
Low High Return Value
99.80 100.00 $5000
99.50 99.79 $10,000
In this case, the return value in worksheet 1 column B would be $10,000 since 99.51 is greater than 99.50 and less than 99.79.
Bookmarks