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


"WJ" wrote in message
...
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