Advance Excel function - Indirect()

@VaibhavJ , Last updated: 04 September 2014  
  Share


To understand benefit of indirect function do as I say. Put 100 in cell A1, now in Cell D1 put formula=INDIRECT(A1) in cell D2 put formula=A1. Result is same in both case then why to put confusing formula in cell D2? Now select column A delete it! What you see now in C

You have reached daily limit of 2 Free Articles. To view this or other Articles please subscribe to CCI PRO :

GST Plus

Stay updated! Stay ads free

Browse CAclubindia ads free.
Latest updates on WA.
Daily E-Newsletter and much more.

CCI PRO annual subscription :

Original Price : INR 1999/-

Offer Price : INR 999/-

Duration : 1 year
(Prices Inclusive of GST)


Know More

Note: If you are a PRO member already, please click here to login (for ad free experience)
Join CCI Pro

Published by

@VaibhavJ
(Believe!! Live your dreams!)
Category Info Technology   Report

  32954 Views

Comments


Related Articles


Loading