'how to fill a complete column with arrayformula and containing Vlookup of base on a single cell criterion
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
Solution 1:[1]
use:
=INDEX(IFNA(VLOOKUP('Target Sheet'!G1:G,
IMPORTRANGE("MYLIST", "FileLInktoAgent!A2:C45"), 2, 0)))
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | player0 |