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

01-29-2022, 08:13 PM

spillerbd

Windows 10 lookup the date beside a cell that matches a value

Office 2013

Competent Performer

Join Date: Jan 2016

Posts: 130

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

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 04:06 AM.