Originally Posted by
Ochimus
JB20,
Think the attached does what you want?
You can test it by changing the Units, Jobs and dates in the Entry sheet.
It uses an "Index/Match" array (entered with Ctrl+Shift+Enter) against the three criteria:
{=IFERROR(INDEX(ENTRY!$C$3:$C$8,MATCH(1,IF(B$2>=ENTRY!$D$3:$D$8,IF(B$2<=ENTRY!$E$3:$E$8,IF($A4=ENTRY!$B$3:$B$8,1)),0))),"SHOP")}
(Look in Col C of the Entry form and find the row where the date in Col D is more than or equal to the date in Row 2 of the Calander sheet, the date in Col E is less than or equal to it, and the Data in Col B matches the row in Col A of the Calender sheet, If there is no match, put "Shop" in the cell,)
Hope it helps
Ochimus
Bookmarks