lookup the date beside a cell that matches a value

		Microsoft Office Forums > Microsoft Excel > Excel
lookup the date beside a cell that matches a value

FAQ

Thread Tools

Display Modes

01-29-2022, 02:38 PM

oscarlimerick oscarlimerick is offline

lookup the date beside a cell that matches a value

Windows 8

Office 2013

Advanced Beginner

Join Date: Jul 2020

Posts: 82

oscarlimerick is on a distinguished road

lookup the date beside a cell that matches a value

Hi folks, please see attached spreadsheet. I need to have excel look for a minimum and maximum value in a cell (column) range, and then report the corresponding date that is associated with that cell. I think I probably need to use lookup, match, index, or a combination of these values in my formula. Any suggestions. Thanks

Attached Files

FOR EXCEL FORUM.xlsx (8.7 KB, 10 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help required: Combining multiple matches in to a single cell	Cantora	Excel	7	01-29-2020 04:08 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
LOOKUP - Complex lookup with 2 lookups in 1 cell	sglandon	Excel	6	05-05-2016 09:44 AM
cell text to auto populate if criteria matches	Jackie	Excel	2	02-06-2015 07:58 PM
How to conditionally format cells in Col. A if it matches adjacent cell in Col. B?	alshcover	Excel	2	06-03-2014 12:50 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:48 AM.