Index/Match Array Formula to Retrieve Data from Closed Source File

[Howardjo]

Morning,

I've been using the below formula to extract data from a table stored in a source file called Central Log.xlsm.

=INDEX('Central Log.xlsm'!Table27[[#All],[Region]],MATCH($D$5,'Central Log.xlsm'!Table27[[#All],[Name]],0))

What I've been trying to do is convert this to an array formula which will complete the lookup when the source file is closed. (Currently this only populates when I have 'Central Log.xlsm' open).

I know this is possible to achieve with a simple VLOOKUP, but wondered if it was possible using INDEX/MATCH?

Regards

 

[Aladin Akyurek]

Brilliant, thank you.

You are welcome.