You could try a combination of INDEX() and MATCH(). Let us know how your data
is arranged...

--
Jacob


"Corca" wrote:

Hi,

Need help please with:

I have a data sheet with many columns of data. I have another sheet with a
summary of some of the data as follow:

Result sheet has a name column and a high score column. I used the large
function to find the 84. Now i need a formula to find the 84 on the data
sheet and the go accross the same row to get name and place it on the result
sheet under name beside the 84.


The data sheet has about 60 columns, the 84 is found on 6 columns all next
to each other no in a single column.

Can someone help please.

Name High score
??????? 84