On 15 Nov, 11:39, muddan madhu wrote:
Try this

=IF(AND(A70=3,A70<=53),INDIRECT("C"&A70))

On Nov 15, 4:09*pm, Johnnyboy5
wrote:

I need to use the IF 53 times ! I have 53 rows which I am using filter
and *Subtotal (row70) *I need to get one of the columns "C" to enter
its text (names) into the subtotal row 70.

However I can only use the brackets up to 9 times ( I think) can does
anyone know how to reduce the formula size. *I need to get A70 up to
=53 and likewise with the C column.

=IF(A70=3,C3,IF(A70=4,C4,IF(A70=5,C5,IF(A70=6,C6,I F(A70=6,C6,IF
(A70=7,C7,IF(A70=8,C8,
IF(A70=9,C9))))))))

Row 70 works like this
if the subtotal in column A row 70 = 5 then in the subtotal column C
(where the above formula is) it puts the name of the person, * all the
other subtotal columns are for data and they work fine. * This does
what I need but I need but only up to number 9, I need to get the
"equals" up to number 53 and therefore the C part of the formula up to
53.

thanks everyboy how reads these posts.

You are a STAR... thank you so much it works really well...thanks
again, you have saved me from going mad