extend index & match function

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

try

=INDEX(Sheet2!$B$2:$B$7,MATCH(Leave!$A2&Leave!$B2,Sheet2!$A$2:$A$7&Sheet2!$B$2:$B$7,0))

enter with Ctrl+Shift+Enter

and change your dates to Excel dates; do not use TEXT dates ( use Text-to-Columns to convert)