Multiple indexing arrays?

**Tony Valko** · 12-15-2013, 04:08 PM

Maybe this...

=INDEX(IF(Y2=1,$AA$8:$AA$12,$AB$8:$AB$12),MATCH(Y8,$Y$8:$Y$12,0))

**sperrysperry** · 12-15-2013, 04:52 PM

That works fine for y2=1. I added a coma and duplicated what you have for y2=2, but all I got were excel error messages. (I tried different combinations of "if"'s and "index"'s, to no avail.

**Tony Valko** · 12-15-2013, 05:07 PM

If there are only 2 options for Y2, Y2 = 1 or Y2 = 2, then don't make any changes to the formula.

Another way to write it would be:

=INDEX(CHOOSE(Y2,$AA$8:$AA$12,$AB$8:$AB$12),MATCH(Y8,$Y$8:$Y$12,0))