Microsoft Office Forums - View Single Post - [Solved] lookup the date beside a cell that matches a value

Thread: [Solved] lookup the date beside a cell that matches a value

View Single Post

Old

01-29-2022, 08:13 PM

spillerbd

spillerbd is offline

spillerbd uses Windows 10

Windows 10 spillerbd uses Office 2013

spillerbd uses Office 2013

Office 2013

Competent Performer

Join Date: Jan 2016

Posts: 130

spillerbd is on a distinguished road

Default

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

Reply With Quote