Indirect vs. Index

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, can someone explain to me what's the main difference between INDIRECT and
INDEX? When should we use indirect and when should we use index?

Thank you in advance.

WJ
 
They are two largely unrelated functions. Which to use depends on
what you want to accomplish.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
I think Indirect and Index can both be used to return the value of a cell at
a specific location. The difference is that Indirect will return a fixed
reference, but index cannot do that. Am I correct?
 
You must log in or register to reply here.

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

Using INDIRECT Function and INDEX Function 1
IF(ISNA.. or ISERROR? question.. 3
Indirect 1
INDEX("a"&COLUMNS(INDIRECT(A1):INDIRECT(A2)):A30,4) 3
Excel EXCEL - Set non-continuous PrintArea via Function / Name 0
Set non-continuous PrintArea via Function / Name 0
Creating a Unique List 5
Problem using ADDRESS() in SUMPRODUCT() 2

Back
Top