Lookup based on date but pull in duplicate fields to another sheet

[Jersey1972]

I am trying to combine vacation schedules into one sheet, I need to be able to pull all data including duplicate fields based on date, I was able to pull information with this formula: =TRANSPOSE(IFERROR(IF(VLOOKUP(G3,'Electric Shop'!A7:E198,{2,3,4,5},FALSE)=0,"",VLOOKUP('Main Sheet'!G3,'Electric Shop'!A7:E198,{2,3,4,5},FALSE)),""))...However, it was not pulling the data with the duplicate dates as needed: For example, Jan 27th, it only pulls the first entry for the date, and I need it pull all entries for that date, as the whole spreadsheet will fill up for every cell as the months progress into summer.

27-Jan	Shawn Ockerman (29-FH)	Grant Gaither (28-FH)
27-Jan	Grant Gaither (27-PLAWA)
27-Jan	Darren Boatman (28-5hrs-PLAWA)

 

[PeteWright]

Hi @Jersey1972
Could you provide a little more data and an example output? I can't figure out what data should be pulled since you have two entries of "Grant Gaither" with different suffix.
A sample set of about 10 to 20 entries and the resulting desired output would be nice so I get a picture of what should happen there.
Thanks

 

[Jersey1972]

I have a workbook for a vacation schedule between departments, that I am trying to compile to one master sheet based on date, where there can be the same person taking different days or 2hrs a day, i.e Jane Doe 23-FH, Jane Doe 25-28 PLAWA and Jane Doe 29 (2hr PM). Each department is allotted a quota that they are allowed to have off at one time, so that changes between departments. On the master sheet which will be the first sheet that I will attach, there will be 8 cells for each date, that has been the problem with the sheet, the vlookup only identifies the first cell with the date, the second sheet I attach is a screen shot of one of the departments that I am pulling to the main sheet.

As you can see for February 3rd, I have (3) cells with information, but on the master sheet, it is only pulling the first one. I am aware I have not unmerged the date cell, nevertheless, it doesn't pull the information. We keep the first row of cells open for full week vacation, then we add in the day, 1/2 day, and so forth in the lower cells. Our current way of doing this is entering the time off in both places, and it can become cumbersome with all the changes for over 100 employees.