Forum Discussion
Solved
Pull values from range to calendar w/ criteria.
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 exa...
In V2:
=FILTER($S$2:$S$1000, ($Q$2:$Q$1000=V$1)*($R$2:$R$1000=$U2), "")
Fill down and to the right.
In V2:
=FILTER($S$2:$S$1000, ($Q$2:$Q$1000=V$1)*($R$2:$R$1000=$U2), "")
Fill down and to the right.
Awesome! I thought about trying to use FILTER, but just couldn't work it out. Thanks a lot!