Forumal help, Indexing or If or ??

**apiske148** · 11-30-2011, 05:21 PM

I have a spreedsheet that has 3 columns, I have trying to have the last one filled in automatically. Column C will be a result of A and B together and output a number 1-25. So if A1=1 and B1=1 then C1=25 If A1=2 and B1=1 then C1=24 If A1=1 and B1=2 then C1=23 and so on until A1=5 and B1=5 then C1=1

So I am dealing with potentially 25 If statements per column and not even sure that thats possible, would indexing arrays be an option if so how? there are 20-30 rows and this same forumal will be used on several sheets so if I can get it figured out it would be worth the time as it will be used often.

Any and all help greatly appreciated!

**tigeravatar** · 11-30-2011, 05:58 PM

apiske148,

I don't understand your pattern. Can you post a sample workbook showing the pattern, or provide the logic behind the pattern?

**Special-K** · 11-30-2011, 05:59 PM

Try

=25-(B1-1)*5-(A1-1)
and copy down column C

**tigeravatar** · 11-30-2011, 06:06 PM

Special-K,

That formula doesn't quite fit. Here's a table of his examples:

Col A    Col B    Col C
  1        1        25
  2        1        24
  1        2        23
  .        .        .
  .        .        .
  .        .        .
  5        5        1

Using your formula with the third set of numbers, you get:
=25-(2-1)*5-(1-1)
=25-(1)*5-(0)
=25-5
=20

which is an incorrect result...