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)}
Bookmarks