I have a large data set that has multiple different columns on one sheet labeled "Status".

In column E labeled "Action" there are various inputs and I am trying to pull data(in form of text) from every row that is marked as "ends" to another sheet.

A Vlookup would be ideal but since the characters do not have unique values it will only generate the first row it finds.

The only way I see this to work is you can create a filter for column E Labeled "Action" to sort only "ends". Then copy and past that information onto another sheet.

The "Status" sheet will be updated regularly and new data needs to be able to get pulled.

I hope there is a way to do this as I have been trying everything I can with my knowledge. Please help.

Thanks