Try this:

Sheet1 A2:A10 = client names
Sheet1 B2:B10 = percentage

Sheet2 A1 = percentage to use as the lookup criteria: 50%
Sheet2 A2 enter this formula as an array using the key combination of
CTRL,SHIFT,ENTER (not just ENTER):

=IF(ROWS(A$1:A1)<=COUNTIF(Sheet1!B$2:B$10,""&A$1) ,INDEX(Sheet1!A$2:A$10,SMALL(IF(Sheet1!B$2:B$10A$ 1,ROW(Sheet1!A$2:A$10)-ROW(Sheet1!A$2)+1),ROWS(A$1:A1))),"")

Copy down to A10.

Here's a sample file:

sample_extract1.xls 15kb

http://cjoint.com/?kmagXYXIkn

Biff

"360Kid" wrote in message
...
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.