formula help - value in cell looking up row and column using great than less than

		Microsoft Office Forums > Microsoft Excel > Excel
formula help - value in cell looking up row and column using great than less than

10-20-2017, 09:34 AM

Debaser

Windows 7 64bit formula help - value in cell looking up row and column using great than less than

Office 2010 32bit

Competent Performer

Join Date: Oct 2015

Location: UK

Posts: 221

If you list the start values for each range, you can use INDEX and MATCH as in the attached.

Attached Files

Book1.xlsx (10.8 KB, 12 views)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Is it possible to put a formula in a table column header to define the name of the column?	JacquesW	Excel	3	05-08-2017 08:00 AM
Entering a column value in a cell, to be used as part of a reference in a formula in another cell	paulkaye	Excel	4	02-26-2017 04:18 AM
If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C	rick10r	Excel	1	07-05-2016 12:07 PM
What formula can I use to find the lowest cell in a column that has a value in it?	EddyWD	Excel	3	04-20-2016 09:29 PM
Need help with dragging a formula and changing a reference column as I drag the formula.	LupeB	Excel	1	10-22-2015 03:02 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:59 AM.