In B3:
=INDEX(wkly!X$34:X$37,MATCH(LARGE(wkly!$W$34:$W$37 ,ROWS($1:1)),wkly!$W$34:$W$37,0))
Copy B3 to C3, fill down as far as required
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"jeel" wrote in message
...
I have 3 columns of info to move to next worksheet. On new sheet I set one
column to bring me the numbers in order--large1, etc thru 4. I would like
a
formula or function to bring me the info in the next column, same row. And
also the info in the third column. For example-in cell a3, the formula
is=LARGE(wkly!w34:w37,1).It gave me the value 323 which is wkly!w35. In
cell
b3 I want the info in wkly!x35, in cell c3 I want the value from wkly!y35,
so
that all 3 columns match based on the
large1, large2, large3, and large4. If I bring all the info to the next
page
with copy and then sort it messes up all my calculation formulas in
columns
d,e, f, etc. I am working in groups of 4. Thank you