Vlook up between two google sheets

user_15558113 0
Viewed 30

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")

enter image description here

vlookup google-sheets-formula google-sheets import arrays
1 Answers

try in I2:

=INDEX(IFNA(VLOOKUP(B2:B; IMPORTRANGE("id"; "Sheet!!A:B"); 2; 0)))
user_56326290
Related