I have two google sheet workbooks. On the untitled Spreadsheet workbook I want the link that’s on Colm B to appear from "links" workbook to appear on column I on the "untitled spreadsheet" when the trailer appears on column B.
I have this
=QUERY(IMPORTRANGE("I will put the http for the Link spreadsheet here ,"Sheet!!A1:B")
>Solution :
try in I2:
=INDEX(IFNA(VLOOKUP(B2:B; IMPORTRANGE("id"; "Sheet!!A:B"); 2; 0)))