Scribd
Upload
4 views4 pages

Understanding the INDIRECT Function in Excel

Uploaded by

nexaconalok
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
4 views4 pages

Understanding the INDIRECT Function in Excel

Uploaded by

nexaconalok
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

INDIRECT FUNCTION

INDIRECT formula returns the reference specified by the text string


Note
- It is a volatile formula (use with caution) Means it recalculate the workbook or workshe
The Reference Text (ref_text) could be:
-- A reference to a cell that in-turn contains a cell reference in A1-style or R1C1-style format
-- A reference to a cell in double quotes
-- A named range that returns a referenc

Formula Result Remarks


=indirect("h10") 10 Returns the value in cell F10
=indirect("innozant_nr") #REF! Returns the value of the named range
=indirect(h12) Innozant Refers to h12,which redirects to h11 and returns the value in h11

SALE SALE SALE


DELHI 2340 2234 5532
GURGAON 2233 4433 3424
GHAZIABAD 2222 4433 2423
FARIDABAD 3532 4324 2134

Type Cell Address d19

Value in the Cell

Type the Name of Sheet Aarti


Type the cell to pick data from i3
The content of cell 4354 4354

Type the Name of Sheet Aarti


Type the start cell of the range e3
Type the end cell of the range k3 32228
The sum of Range is 32228
he workbook or worksheet whenever there is any change

Value
10
Innozant
H11

returns the value in h11


Jan Feb Mar Apr May Jun Jul Aug
Sales 2324 6666 7777 4544 6565 2323 4354 3322
Sep Oct Nov Dec
3343 5435 3433 5334

You might also like