Formula for adding dates to a Calendar

[fugro]

Hi all,

I posted earlier in the week relating to this same worksheet I am working on. I eventually thought it was finished but I now find a have a problem...if I input more than one leave period for an employee, for each period (ie: JAN JUN), this does not show on the corresponding Jan Jun/ Jul Dec sheet (Calendar)

Data inputted in Sheet "EmployeeData" (Note CTRL-Z brings up calendar for inputting dates)

2 sheets - "JAN JUN" & "JUL DEC" use VLOOKUP functions (from BQ4 - BS603 EmployeeData) where I have a representation of leave taken. Notice only one period in each, where-as 2 for each inputted...

Please see the workbook attached for more info.

If I am using the wrong function I will change the title for this thread once I know, for future ref.

Best regards and thanks in advance for your time.

Warren...ultra novice but learning!

[fugro]

Bump...Thought maybe the title is better as vlookup maybe not correct?

Any help appreciated!

[fugro]

This is the code I am using

=IF(AND(I$1>=VLOOKUP($D6,EmployeeData!$BQ$4:$BS$603,2,FALSE),'JAN JUN'!I$1<=VLOOKUP('JAN JUN'!$D6,EmployeeData!$BQ$4:$BS$603,3,FALSE)),TRUE,FALSE)

I see from other posts that VLOOKUP only returns 1st value...how do i get around this?

Thanks