Hi everyone,
I would like to extend the index-match function i have used. Currently it returns the date found in sheet 2 if the first column is a match with the data in the leave sheet. I would like it to match & return the second column if the first column (ID) & the second column(Start date) match with the code & dateFrom columns in Sheet2.
For 10-May-2019 on leave sheet the result column should show n/a.
Thank you
Bookmarks