Hi all,

I have a table located on one worksheet that contains some columns & rows that I want to pull into a second table.

So for example, from my table called FY22_Q1 column [Classification] any time the word "Production" comes up, I want to pull the information in the [Name] column onto my new table.

Can anyone help?