put the value of a cell in one worksheet in another worksheet based on a criteria

[tbrynard01]

This is my source data on worksheet 1:

Column 1	Column 2
Name	Date
Peter
Joe	A
Mary
Nancy	A

In worksheet 2 I would like the names listed of all who have an A in the date column, I've tried index and match but am not getting the correct results. I'm not able to move the columns around and I don't want to pull in anything that is blank in column 2

Any advice?

Thanks

 

[Fluff]

How about

Book1
	A	B
1	Name	Date
2	Peter
3	Joe	A
4	Mary
5	Nancy	A
Sheet1

Book1
	A
1	Names
2	Joe
3	Nancy
4
5
6
Sheet2

Cell Formulas
Range	Formula
A2:A6	A2	=IFERROR(INDEX(Sheet1!$A$1:$A$99,AGGREGATE(15,6,(ROW(Sheet1!$A$1:$A$99)-ROW(Sheet1!$A$1)+1)/(Sheet1!$B$1:$B$99="A"),ROWS($A$2:$A2))),"")

 

[tbrynard01]

Thank you so much, that worked!

 

[Fluff]

You're welcome & thanks for the feedback