I'm trying to use the formula below and add IMPORTRANGE but the importrange formula showing an error, would you please help?
Original formula:
=IFERROR(VLOOKUP(INDEX($B$2:$B$6,SUMPRODUCT(($A$2:$A$6=$A9)*($C$2:$I$6=B$8)*(ROW($B$2:$B$6)))-ROW($B$2)+1),$K:$L,2,0),"")
Added Importrange:
=IFERROR(VLOOKUP(INDEX((IMPORTRANGE("LINK","TAB!$B$2:$B$6")),SUMPRODUCT(((IMPORTRANGE("LINK","TAB!$A$2:$A$6"))=$A9)*((IMPORTRANGE("LINK","TAB!$C$2:$I$6"))=B$8)*(ROW(IMPORTRANGE("LINK","TAB!$B$2:$B$6)))))-ROW((IMPORTRANGE("LINK","TAB!$B$2")))+1),$K:$L,2,0),"")
Bookmarks