Pulling specific info from one sheet to another if it meets criteria

Howdy y'all,

In the attached file the desired result is on the Priority sheet. In the Daily sheet, if column B is Set or Pull I want the value in column A to be shown in the 1st available cell in column A of the Priority sheet. I would like this to then repeat process to repeat.
I have tried a few things like and If formula and that wouldn't place the information on the next cell, it would match the cell from the Daily sheet to the Priority sheet, also, it wouldn't pull all the information over. I also tried Vlookup, but all that would do was pull the same value from Daily to Priority, meaning all the cells in Priority would have 1A in them.
TL Daily.xlsx

Like this...

Data Range

	A	B	C	D
2	WORK CENTER	PULL	SET	PRIORITY
3	1B		Needs
4	2A		Needs
5	3B	Needs
6	5A		Needs
7	5B	Needs
8	6A	Needs
9	9A	Needs

This formula entered in B3:

=IF(COUNTIFS(Daily!$A$2:$A$15,$A3,Daily!$B$2:$B$15,B$2),"Needs","")

Copy across to D3 then down as needed.

Tony,
Thank you for the help. I was working on how to figure out that part of it as well, but, what I was actually trying to get was the value from column A from the daily sheet to the next blank cell in column A of the Priority sheet if column B on the Daily sheet is "Set" or "Pull.

Not a problem...

Data Range

	A	B	C	D
2	WORK CENTER	PULL	SET	PRIORITY
3	1B		Needs
4	2A		Needs
5	3B	Needs
6	5A		Needs
7	5B	Needs
8	6A	Needs
9	9A	Needs
10

This array formula** entered in A3:

=IFERROR(INDEX(Daily!A:A,SMALL(IF(ISNUMBER(MATCH(Daily!B$2:B$15,B$2:C$2,0)),ROW(Daily!B$2:B$15)),ROWS(A$3:A3))),"")

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Copy down until you get blanks.

Well, I tried what you suggested and the key combination isn't working. As soon as I paste the formula into the cell, 1A shows up in the cell and it should be 1B as that is the 1st one that has Set or Pull in column B. Also, if I'm not mistaken, when I press Ctrl, Shift (and hold them down) and then Enter, aren't brackets {} supposed to show up around the formula? That's not happening when I do it.

I figured it out...for some reason, I had to click in the formula bar 1st and then hit the key combination....it's working now.

Thanks a bunch Tony!

Originally Posted by gmr4evr1

when I press Ctrl, Shift (and hold them down) and then Enter, aren't brackets {} supposed to show up around the formula?

Yes

Here's your file with the formulas implemented.

Good deal. Thanks for the feedback!