I have a sheet with columns of clients and percentages. I would like a new
sheet to pull only those client names that exceed a certain percentage i.e.
50% and create a list with only those clients.

Is there a lookup function that can do this?

thanks loads.