Good Day!
I searched the internet but can't find the right way to get it to work. Don't know where to put the : [] \ .....
I want an index match which retrieves data that is located in another workbook (which is not open/active, no idea if this important).
Path = X:\Data\Metro Communication\01 - AUTOMATIC ORDERING METRO\03 - AANVRAAG - DEMANDE![]()
=INDEX(X:\Data\Metro Communication\01 - AUTOMATIC ORDERING METRO\03 - AANVRAAG - DEMANDE\STOCKMODEL voor templates.xlsb:[21]$H$1:$Y$70000;MATCH(B8;X:\Data\Metro Communication\01 - AUTOMATIC ORDERING METRO\03 - AANVRAAG - DEMANDE:[STOCKMODEL voor templates.xlsb]21'!$H$1:$H$70000);MATCH($C$7;X:\Data\Metro Communication\01 - AUTOMATIC ORDERING METRO\03 - AANVRAAG - DEMANDE:[STOCKMODEL voor templates.xlsb]21'!$H$1:$Y$1))
File = STOCKMODEL voor templates.xlsb
Sheet= 21
Bookmarks