Thread: formula help - value in cell looking up row and column using great than less than
View Single Post
 
Old 10-20-2017, 09:34 AM
Debaser's Avatar
Debaser Debaser is offline Windows 7 64bit Office 2010 32bit
Competent Performer
  
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default
If you list the start values for each range, you can use INDEX and MATCH as in the attached.
Attached Files
File Type: xlsx Book1.xlsx (10.8 KB, 12 views)
Reply With Quote