Use Indirect to lookup in another workbook

Are there any limitations as to the number of sheets, the drive where the target workbook is located or the number of caracters of the target workbook?

Im using a fomular like this : INDIRECT(“‘[” & A2 & “]” & A3 & “‘!” & A4) , name of workbook, sheet and cell address

But is does not work. The target is a workbook with 5o sheets

 

By: Michael

Leave a Reply

Your email address will not be published. Required fields are marked *