IMPORTRANGE中的VLOOKUP [英] VLOOKUP within IMPORTRANGE
本文介绍了IMPORTRANGE中的VLOOKUP的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
为了在VLOOKUP之后在工作表中收集一个值，我正在Google电子表格上尝试此功能而未成功:
I'm trying this function on Google spreadsheet without success in order to gather in a sheet a value after a VLOOKUP:
=importrange("otherurl";cell("address";vlookup(value("201608"),"All_nodevice!$A$16:$C$1000",2,false)))
我遇到一般错误.
IMPORTRANGE是否支持这种功能?
Does IMPORTRANGE support this kind of functionality?
我需要做的是从另一张左侧值为201608的工作表的单元格中提取数据.由于IMORTRANGE想要像$ A $ 12这样的单元格指针，因此我想执行以下步骤:
What I need to do is to extract data from the cell of another sheet that has the value 201608 on its left. Since IMORTRANGE wants a cell pointer such as $A$12, I thought to do these steps:
- 使用查找值进行搜索.
- 将结果转换为单元格指针.
推荐答案
我找到了正确的方法.可能对其他人有用.
I found the right way. May be it could be useful for someone else.
=VLOOKUP(201608;IMPORTRANGE("sheet url"; "All_nodevice!$A$16:$C$1000"); 2; 0)
或
=query(IMPORTRANGE("sheet url";"All_nodevice!$A$16:$C$1000");"select Col2 where Col1=201608 limit 1")
这篇关于IMPORTRANGE中的VLOOKUP的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
