Array formula not calculating in linked workbooks

[Stuepef]

I currently have a workbook with over 50,000 rows of data based on color, make, model, package, year and price of cars and I'm using an array formula to retrieve price based on multiple criteria. The formula works perfectly when all information is in one workbook, but the array formula does not work when I separate the data in one workbook and the formula in a different workbook. Is there an alternative method to write the formula so I can leave the data set in a separate workbook?

Here is the data set format:
Column A - Color
Column B - Make
Column C - Model
Column D - Package
Column E - Year
Column F - Price

Example output (user selects the combinations):
Cell J2 - Red
Cell K2 - Ford
Cell L2 - Mustang
Cell M2 - GT
Cell N2 - 1967
Formula below = $25,000

Here is the formula:

{=INDEX($F$:$F$,MATCH(1,(J2=$A$:$A$)*(K2=$B$:$B$)*(L2=$C$:$C$)*(M2=$D$:$D$)*(N2=$E$:$E$),0))}

 

[offthelip]

you could try something like this (also an array formula):

{=MATCH(H3&I3&J3,CONCATENATE(D3:D7,E3:E7,F3:F7),0)

}
I don't know whether it will solve our problem but it is worth trying since it is a slightly different way of doing it.
Note I haven't put the correct cell references in, I just tried it quickly.

 

[Aladin Akyurek]

Control+shift+enter, not just enter:

=INDEX([Book1]Sheet1!$F$2:$F$10,MATCH(1,(J2=[Book1]Sheet1!$A$2:$A$10)*(K2=[Book1]Sheet1!$B2:$B$10)*(L2=[Book1]Sheet1!$C$2:$C$10)*(M2=[Book1]Sheet1!$D$2:$D$10)*(N2=[Book1]Sheet1!$E$2:$E$10),0))