lookup the date beside a cell that matches a value

oscarlimerick · #1 01-29-2022, 02:38 PM

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

spillerbd · #2 01-29-2022, 08:13 PM

=index($a$4:$a$7,match($e1,$b$4:$b$7,0))
=index($a$4:$a$7,match($e2,$b$4:$b$7,0))

oscarlimerick · #3 01-30-2022, 09:38 AM

Yes, that works perfectly, I knew it was those functions or a combination of them. Thanks for the quick reply!

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