If you have duplicate names, this will only returns first employee's date
=INDEX(Sheet1!C4:H4,MATCH("A",INDEX(Sheet1!C5:H9,MATCH(C5,names,0),0),0))
If you have duplicate names, this will only returns first employee's date
=INDEX(Sheet1!C4:H4,MATCH("A",INDEX(Sheet1!C5:H9,MATCH(C5,names,0),0),0))
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks