pulling names from 1 spreadsheet to another only if they are in a particular skill set

[RMJ]

Hello,

Hope everyone is having a good day; and have a good weekend.

Still working on my spreadsheet.

I'm working with 2 spreadsheets. The 1st spreadsheet has a list of team members that can work a particular queue; and the names change daily. Please see example:

			20-Jul​	21-Jul​	22-Jul​	23-Jul​	24-Jul​	29-Jul​	30-Jul​	31-Jul​
u234987	John	Nathers	LA	LA	LA	LA		LA	LA	LA
a569254	Susan	Porter		LA		LA	LA	LA		LA
davma00	Nahalia	Simms	LA	LA		LA		LA		LA
u874139	Taylor	Jones			LA	LA	LA	LA	LA	LA
	4​
	7/29/2020​

The formula in B4 is: =SUMPRODUCT(($D$3:$J$6="LA")*(--$D$2:$J$2=TODAY())) - Thank you Toadstool
The number that appears in cell B4 is then shown on the 2nd spreadsheet
Now, I'm trying to find a way for me to show the names of those team members that are working the LA queue only on a specific day in a section on the 2nd spreadsheet. Instead of copying and pasting. I'm thinking something like this:

Team Member Working LA
John Nathers
Susan Porter
Nahalia Simms
Taylor Jones

I tried different formulas and still trying; but one that i used recently is: =IF(Sheet3!K3:K6="SKP",VLOOKUP(A2,Sheet3!A1:C6,2,FALSE),VLOOKUP(B2,Sheet3!A1:C6,3,FALSE))
but I realized that it doesn't give the flexibility that I need to keep the information changing from day to day nor does it contain a date for the system to reference.
Not sure what is best. I tried using Index and Match, Search formulas.
Any help is much appreciated.
I'll be checking out other options too.

Thank you in advance,
RMJ

 

[Fluff]

How about

+Fluff New.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1				20/07/2020	21/07/2020	22/07/2020	23/07/2020	24/07/2020	29/07/2020	30/07/2020	31/07/2020
2	u234987	John	Nathers	LA	LA	LA	LA		LA	LA	LA
3	a569254	Susan	Porter		LA		LA	LA	LA		LA
4	davma00	Nahalia	Simms	LA	LA		LA		LA		LA
5	u874139	Taylor	Jones			LA	LA	LA	LA	LA	LA
6
7
8
9
10
11
12
13	LA	30/07/2020
14	John	Nathers
15	Taylor	Jones
16
17
18
19
Sheet1

Cell Formulas
Range	Formula
A14:B18	A14	=IFERROR(INDEX(B$2:B$5,AGGREGATE(15,6,(ROW($B$2:$B$5)-ROW($B$2)+1)/(($D$1:$K$1=$B$13)*($D$2:$K$5=$A$13)),ROWS(A$14:A14))),"")

 

[RMJ]

How about

+Fluff New.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1				20/07/2020	21/07/2020	22/07/2020	23/07/2020	24/07/2020	29/07/2020	30/07/2020	31/07/2020
2	u234987	John	Nathers	LA	LA	LA	LA		LA	LA	LA
3	a569254	Susan	Porter		LA		LA	LA	LA		LA
4	davma00	Nahalia	Simms	LA	LA		LA		LA		LA
5	u874139	Taylor	Jones			LA	LA	LA	LA	LA	LA
6
7
8
9
10
11
12
13	LA	30/07/2020
14	John	Nathers
15	Taylor	Jones
16
17
18
19
Sheet1

Cell Formulas
Range	Formula
A14:B18	A14	=IFERROR(INDEX(B$2:B$5,AGGREGATE(15,6,(ROW($B$2:$B$5)-ROW($B$2)+1)/(($D$1:$K$1=$B$13)*($D$2:$K$5=$A$13)),ROWS(A$14:A14))),"")

Thank you for responding.
I'm not sure where I am going wrong. When I apply the formula to the spreadsheet, the return data is for someone that is not scheduled to work that queue.
I'll to working on it.
P.S. is that the Lancashire Rose ?

 

[Fluff]

Can you post your data using the XL2BB add-in as I did in post#2, that way it's possible to see what rows/columns your data is in?

 

[RMJ]

Hello,

Hope you had a wonderful weekend.

I'm not sure what I was doing wrong on Friday; but I went back today; and started from scratch; and it worked.

I do apologize for the inconvenience.

Thank you for your help.

RMJ

 

[Fluff]

Glad you got it sorted & thanks for the feedback.