indirect worksheet function in excel

R

richard_annor

I still do not understand how the above function works. I want to know if you
have to name your value cells to reflect the reference cells or what? Can you
give me more elaborate illustration than what is in the help section. It is
not helping me at all. thank you
 
F

Fredrik Wahlgren

richard_annor said:
I still do not understand how the above function works. I want to know if you
have to name your value cells to reflect the reference cells or what? Can you
give me more elaborate illustration than what is in the help section. It is
not helping me at all. thank you
Click to expand...

Here are a few examples.
http://www.cpearson.com/excel/indirect.htm

/Fredrik
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
Using SUM(INDIRECT()) 2
How to update data entry to a linked worksheet and then return thenew value back to a master workshe 0
Indirect function and relative references 4
Calculate the median value before a specified list 0
INDIRECT function to reference a named range 2
Create Range by joining multiple Ranges - passing multiple holidayranges to Workday function 6

Top