What does indirect function do in excel?



What does indirect function do in excel?..

Answer / 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

More MS Excel Microsoft Interview Questions

How many rows can csv handle?

1 Answers  


Where is countif function in excel?

1 Answers  


Can you use vlookup in a table?

1 Answers  


What are some disadvantages of using excel?

1 Answers  


What does ctrl 0 do in excel?

1 Answers  


How do you split a table?

1 Answers  


How do you compare two excel sheets and highlight the difference?

1 Answers  


How do I open scenario manager in excel?

1 Answers  


How do I merge cells into one row?

1 Answers  


How do you create a worksheet?

1 Answers  


What is the shortcut key to increase the font size in excel?

1 Answers  


How do I convert na to blank in excel?

1 Answers  


Categories