Index with large data

Hi,

I have a large group of data, 13 Columns x 154228 Rows. I have 6 index formulas embedded in my working spreadsheet, and it is tedious as it will take me at least 5-10 mins to return a set of 15 values! Sometimes, excel will display the error of "ran out of resources" and I am unable to proceed. Is there other formulas I can use? Or any suggestions?

{=IFERROR(INDEX(SPREADSHEET1!D:M,MATCH(1,(B7=SPREADSHEET1!D:D)*("MASKED1"=SPREADSHEET1!J:J),0),8),"NOT FOUND")}
{=IFERROR(VALUE(INDEX(SPREADSHEET1!D:M,MATCH(1,(B7=SPREADSHEET1!D:D)*("MASKED1"=SPREADSHEET1!J:J),0),10)),0)}

{=IFERROR(INDEX(SPREADSHEET1!D:M,MATCH(1,(B7=SPREADSHEET1!D:D)*("MASKED2"=SPREADSHEET1!J:J),0),8),"NOT FOUND")}
{=IFERROR(VALUE(INDEX(SPREADSHEET1!D:M,MATCH(1,(B7=SPREADSHEET1!D:D)*("MASKED2"=SPREADSHEET1!J:J),0),10)),0)}

{=IFERROR(INDEX(SPREADSHEET1!D:M,MATCH(1,(B7=SPREADSHEET1!D:D)*("MASKED3"=SPREADSHEET1!J:J),0),8),"NOT FOUND")}
{=IFERROR(VALUE(INDEX(SPREADSHEET1!D:M,MATCH(1,(B7=SPREADSHEET1!D:D)*("MASKED3"=SPREADSHEET1!J:J),0),10)),0)}

Array formulas such as these on that amount of data will certainly cause some slow down.
Perhaps if you post a sample workbook and explain what it is you're trying to do then someone will be able to assist with alternative formulas.

BSB