I am in the process of developing a spreadsheet that pulls values through from other workbooks using VLOOKUP.

I have done this in the past and it works fine irrespective of whether the target workbook is open or not.

On this particular workbook, which uses INDIRECT to generate the target, the VLOOKUP fails if the target workbook is not open giving a REF! error.

I have also tried substituting the INDIRECT function for a direct call and get an N/A error.

I need this to work without the target workbook being open - any ideas why this not working in this instance?

Ed