I am trying to figure out how I can return 6 numbers from 1 row to another
part on my data sheet depending on what result I get

IE: "IF AX67=1 THEN AX67=B1:G1"
OR
"IF AX67=12 THEN AX79=B12:G12"
Iwould like to move 20 lines with 6 cells in a sorted order depending on
result

Do I have to change B1:G1 to a text form to do this?

One way ..

Select a 5 cell horiz range, eg: select AX1:BB1
then place this in the formula bar,
and array-enter the formula by pressing CTRL+SHIFT+ENTER
(instead of just pressing ENTER):
=IF(AX67=1,B1:F1,IF(AX67=12,B12:F12,""))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Old Timer" wrote:
I am trying to figure out how I can return 6 numbers from 1 row to another
part on my data sheet depending on what result I get

IE: "IF AX67=1 THEN AX67=B1:G1"
OR
"IF AX67=12 THEN AX79=B12:G12"
Iwould like to move 20 lines with 6 cells in a sorted order depending on
result

Do I have to change B1:G1 to a text form to do this?