Matt: I think I may understand your problem let me re-state it so we are
clear: You want to serach a list on a different worksheet, 'Sheet 1' and
return 10 values that includes the name and the corresponding # from a list
on "Sheet1".

Please send me an e-mail to: and I'll send you an
excel file with the data and forumlas to accomplish what you want.


"matt" wrote:

Hi,

I'm trying to find out how i can use excel to search through a list of names
and numbers, to find and extract a number that would fit to my criterea.

for example, below is a basic version of my data.

name number

bob 1
mary 2
frank 8
judith 3

now what i would like to do is create some kind of formula that would return
to me, say, the highest number and their name, so it would return:

judith 9

im using it to sort through quite a large list of figures, and i need it to
extract the top 10 figures and names for me.

thanks,

matt