Hi, got the answer
I am using either of these, but the shorter one works just the same.
Thanks for your reply.
Johnnyboy
ROW 70 in the MAIN sheet =IF(AND(A70>=3,A70<=53),INDIRECT
("C"&A70))
ROW 70 in the MAIN sheet =INDIRECT("c" & A70)
On 15 Nov, 12:37, Dilip Pandey wrot
Hi,
Try using this formula instead:
=INDIRECT("C"&A70)
Regards - Dave.
> Date: Sun, 15 Nov 2009 03:39:46 -0800
> Subject: $$Excel-Macros$$ lenghty IF formula
> From: intermediatec...@googlemail.com
> To: excel-macros@googlegroups.com
>
> I need to use the IF 53 times ! I have 53 rows whic
Dear Johnny,
First you should try to identify important factors or key locators in your
data and they you can try SUMPRODUCT formula or some other array
functionality to achieve the desired result.
For better explanation, attach a sample spreadsheet.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-H