LloydFinancials
Well-known Member
- Joined
- Apr 24, 2015
- Messages
- 546
A B
1 (14.73) (16.29)
2 500.00 600.00
3 1,045.92 1,156.02
A is one end of range, B is the other. Formula to determine which range contains the value 501.00 and return the row number. The next list may have 9 rows or more, so cannot enter if statements to check every single row. Formula preferred.
1 (14.73) (16.29)
2 500.00 600.00
3 1,045.92 1,156.02
A is one end of range, B is the other. Formula to determine which range contains the value 501.00 and return the row number. The next list may have 9 rows or more, so cannot enter if statements to check every single row. Formula preferred.