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, 07:28 AM

OTPM

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

Office 2016

Expert

Join Date: Apr 2011

Location: West Midlands

Posts: 981

Hi
This will need testing but this is as close as I can get. I am sure there are more elegant solutions.
Hope this helps.
Tony

Attached Files

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 10:10 AM.