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 |
How many rows can csv handle?
Where is countif function in excel?
Can you use vlookup in a table?
What are some disadvantages of using excel?
What does ctrl 0 do in excel?
How do you split a table?
How do you compare two excel sheets and highlight the difference?
How do I open scenario manager in excel?
How do I merge cells into one row?
How do you create a worksheet?
What is the shortcut key to increase the font size in excel?
How do I convert na to blank in excel?