The "indirect" function allows to decompose your formula and enter the reference cells outside of the formula.
For example if you want to multiply the cells A1 per 10 then you can write the text "A1" in a separate cell (in C1 in the example below) and then simply enter the formula:
=INDIRECT(C1)*10
This function is particularly interesting if you want to apply a certain logic on the reference cells and to control them "outside" of the formula.
The example below show how to retrieve the value of cells A1s of each sheet of the workbook: enter the sheet names in column A, the cells reference in column B and enter the formula:
=INDIRECT(A3&"!"&B3)
Created by DoMyExcel.com © | Excel & VBA Consulting | Customized Excel Solutions starting at 29 USD
Services provided to Individuals and Businesses | Free Quote: DoMyExcel@gmail.com
No comments:
Post a Comment