Simple IF problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,""))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel commands 1
if condition on currency formated cells 4
If formula-different numbers entries 2
Want formula to turn to value by itself 2
Alpha sorting (with a twist...?) 3
Excel How to find the most common pairs and triplets numbers? 5
Find difference between 2 cells if critera in a 3rd cell is met 3
Multiple headings for indexing 4

Back
Top