Hi everyone.

Im putting together a google sheet that uses and array and index to pull data from one tab to another. My next step is to pull this data another sheet using importrange. Ive been successful in doing so using vlookup, but I am stuck and dont know the correct syntax to use it with my current array.

https://docs.google.com/spreadsheets...it?usp=sharing

Heres a link to my sheet. Here is the formula I am using as well.

Thanks in advance for the help!!

ARRAY_CONSTRAIN(ARRAYFORMULA(IF(ISERROR(INDEX('Tech level tracking'!$A$1:$CC$8000,SMALL(IF('Tech level tracking'!$E$1:$E$8000=Store!$D$2,ROW('Tech level tracking'!$A$1:$A$8000)),ROW(4:4)),2)),"",INDEX('Tech level tracking'!$A$1:$CC$8000,SMALL(IF('Tech level tracking'!$E$1:$E$8000=Store!$D$2,ROW('Tech level tracking'!$A$1:$A$8000)),ROW(4:4)),2))), 1, 1)

Chris