Google Sheet IMPORTRANGE

[hj121479]

Based on the below formula, I'm trying to pull data from a separate google workbook.
Let's say the google sheet link is www.abc.com and the tab is Tab. I'm trying to pull the green highlighted range below from the different workbook. How should I use IMPORTRANGE to the below 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),"")

 

[Fluff]

Duplicate to: Google sheet importrange

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.