Could you fill in some sample data in the Result sheet for one date; for example fill in cells G4 and G5 (20 Aug 2019) of the Results sheet with the data you want from employee code 24576 both for Mena~ and BioData, then it will be really clear what you want to see.
For data from the MenaData sheet it's straightforward because there's only one cell to copy from, the formula in cell C4 of the Results sheet could be:
=INDEX(MenaData!$A$1:$AF$100,MATCH($B4,MenaData!$A$1:$A$100,0),MATCH(C$3,MenaData!$A$3:$AZ$3,0))
and copied to the right in that row.
However, for the BioData row (row 5) on the Results sheet, when you say:
Originally Posted by
aligahk06
bioData sheet i.e b4, c4 etc
phrases like 'etc' are difficult to interpret, and there's only one cell for this multi-cell BioData to fit into. So I'm particularly interested in what you want to put in cell G5 of the Results sheet.
For Kenneth Hobs' suggestion that you want just the TimeTable column (E) from the BioData sheet then you could use in cell C5 a formula such as:
=INDEX(BioData!$E$1:$E$10000,MATCH(Result!$B5 & "|" & Result!C$3,BioData!$A$1:$A$10000 & "|" & DATEVALUE(BioData!$B$1:$B$10000),0))
which needs Array-Entering which means committing the formula to the sheet with Ctrl+Shift+Enter, not just Enter. You can copy this to the right across the row too.
Note that that formula has a DateValue function in it because the dates in your BioData sheet column B are not proper dates, just text that look like dates!