ExcelBanter - Indirect.ext

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Indirect.ext (https://www.excelbanter.com/excel-worksheet-functions/264314-indirect-ext.html)

Doug

Indirect.ext

How would I need to type this in? I have tried this several ways. This is
what I have currently and it gives me an
error "A formula in this worksheet contains one or more invalid references."

='C:\Users\The
King''s\Desktop\[test.xlsx]INDIRECT.EXT([book2.xlsx]sheet1'!C1)'!A1

--
Thank you!

Dave Peterson

Indirect.ext

Check you other thread.

Doug wrote:

How would I need to type this in? I have tried this several ways. This is
what I have currently and it gives me an
error "A formula in this worksheet contains one or more invalid references."

='C:\Users\The
King''s\Desktop\[test.xlsx]INDIRECT.EXT([book2.xlsx]sheet1'!C1)'!A1

--
Thank you!

--

Dave Peterson

All times are GMT +1. The time now is 10:37 PM.