Google电子表格查询针对整个列执行 [英] Google spreadsheet query execute for entire column
问题描述
我为两个独立的Google电子表格尝试了 VLOOKUP 函数,但它不支持,所以我通过 使用 QUERY $ c
:
ImportRange
函数的$ c>
= QUERY(ImportRange(sheet key,Course Data!A2:I4),Col2 where Col1 =''& E2&''limit 1)
,它会根据当前工作表 E2
单元的值从第二个电子表格返回值。
我想要实现的是针对整个列(E3,E4,E5 ...)运行此查询。
我是Google Spreadsheets的新手,在互联网上 ARRAYFORMULA
。但我无法在这里申请。
我错了!
VLOOKUP
支持两种不同的电子表格。
这很好:
= ARRAYFORMULA(IFERROR(Vlookup(E2:E,ImportRange(sheets key(url in new sheets),Course Data!A2:I4 ),2,False)))
干杯!
I tried VLOOKUP function for two separate Google spreadsheets but it doesn't support, So I figure it out my required function with a QUERY
using a ImportRange
function.
Here it is:
=QUERY( ImportRange( "sheet key" , "Course Data!A2:I4" ) , "select Col2 where Col1 = '" & E2 & "' limit 1" )
This is execute well for selected cell, it return value from the second spreadsheet according to the value of the current sheet E2
cell.
What I want to achieve is run this query for entire column (E3, E4, E5...)
I am new to Google Spreadsheets and saw something on internet with ARRAYFORMULA
. But I couldn't apply it here.
I was wrong !
VLOOKUP
supports for two different spreadsheets.
This is work fine:
=ARRAYFORMULA(IFERROR(Vlookup(E2:E,ImportRange( "sheets key (url in new sheets)" , "Course Data!A2:I4" ) ,2,False)))
Cheers!
这篇关于Google电子表格查询针对整个列执行的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!