Hi All

I have a table that contains (sheet 1) 2 columns A column contains Team Name, B column contains Staff Name. I am trying to list the Staff Names down column A of a new sheet (Sheet 2) if they = Sheet 2 b1