how to fill a complete column with arrayformula and containing Vlookup of base on a single cell criterion

user_18703908 0
Viewed 13

I need this exact formula into V1:V column

=VLOOKUP('Target Sheet'!$G$1,IMPORTRANGE("MYLIST","FileLInktoAgent!$A$2:$C$45"),2,0)

That formula works perfectly for 1 row, I want all the row to have it

vlookup array-formulas match import arrays
1 Answers

use:

=INDEX(IFNA(VLOOKUP('Target Sheet'!G1:G, 
 IMPORTRANGE("MYLIST", "FileLInktoAgent!A2:C45"), 2, 0)))
user_56326290
Related