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