adspace


What does indirect function do in excel?

Answer Posted / Shyam Sunder

"The INDIRECT function in Excel is used to create a reference to a range or cell specified by a text string. It can make formulas more flexible by allowing you to change the reference at runtime. For example, if A1 contains 'sheet2!A1', INDIRECT(A1) will return the value of cell A1 on sheet2."

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is left formula in excel?

684


Image result for how do I compare two columns in excel

667


Which is latest version of excel?

721


How much is excel for ipad?

713


What is wrap text in excel?

721


Why can't I see the tabs on my excel spreadsheet?

723