'How to add 3 columns on a importrange row with fields that are from lookups
ok, we know : {1,2} will create : a tableau of
| A1 | A2 |
|---|---|
| 1 | 2 |
what I need is :
{Importrange(Souces,"select *"),lookup Employee_name}
to build :
| data1 | data2 | Employee Name |
|---|---|---|
| 1 | 2 | Name of employee |
My current code works great to import Data1 and Data 2, but can't figure out how to include the 3rd column.
=Query(
{
March22!A10:V;
April22!A10:V;
'May22'!A10:V;
June22!A10:V;
July22!A10:V;
August22!A10:V;
September22!A10:V;
October22!A10:V;
November22!A10:V;
December22!A10:V
}
,"Select * where Col3 is not null ")
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
