Pull values from range to calendar w/ criteria.

[TDEP365]

Hi,

Banging my head against a wall trying to pull values (Shift Group) from a range into a calendar based on criteria employee name in Row 1 and the relevant dates in Column U in the pictured example. I basically want to fill out who worked where on each date. Any help is greatly appreciated!

(FYI, using Office 365 on Mac.)

[#2 · Accepted solution]

@TDEP365 

In V2:

=FILTER($S$2:$S$1000, ($Q$2:$Q$1000=V$1)*($R$2:$R$1000=$U2), "")

Fill down and to the right.

[#3]

Awesome! I thought about trying to use FILTER, but just couldn't work it out. Thanks a lot!