Libreoffice:通过FIND(),LOOKUP()或EXACT()引用另一个工作表中的单元格吗? [英] Libreoffice : Referencing cells in another worksheet via FIND(), LOOKUP(), or EXACT()?
问题描述
我正在尝试学习LibreOffice的脚本功能,并且有一种我无法弄清的特定情况.
I'm trying to learn LibreOffice's scripting capabilities, and have a specific scenario that I haven't been able to figure out.
我想做的是通过搜索相邻单元格中的特定值来从另一个工作表中获取值.
What I'm trying to do is get the value from another worksheet, by doing a search for a specific value in an adjacent cell.
例如,假设我有两个工作表:
For example, lets say I have two worksheets:
Worksheet1
Worksheet1
和工作表2
我正在尝试用来自工作表2列B的关联值填充工作表1列B中的每个值.我试图执行此操作的方法是编写查找和使用月份的语句在工作表1中作为针对工作表2的C列的搜索条件.
What i'm trying to do, is populate each value in Worksheet1, Column B with the associated value from Worksheet2, Column B. The way I'm trying to do this is to write a statement that finds and uses the month in Worksheet1 as the search criteria against Worksheet2, Column C.
到目前为止,我的运气还不太好,但这是我一直在努力的目标:
So far I haven't had much luck, but here's what I've been trying to work with:
='Worksheet2'.$C.FIND('Worksheet1'.$A1).$B1
这很可能是错误的,但是我正在尝试表达逻辑,即在Worksheet2中,从Worksheet1:$ A1中找到值,并从Worksheet2:$ B1中给我值"
This is more than likely wrong, but I'm trying to express the logic, which is "in Worksheet2, find the value from Worksheet1:$A1, and give me the value from Worksheet2:$B1"
基本上,归结为我还不了解这种语言的语法和范例.
Essentially what it comes down to is that I do not yet understand the syntax and paradigms of this language.
是否有关于如何实现上面我想做的事情的想法?
Any thoughts on how I can accomplish what I'm trying to do above?
此外,我会对有关该语言的在线教程的任何链接(LibreOffice Basic?)感兴趣.
Also, I would be interested in any links for online tutorials about this language (LibreOffice Basic?)
提前谢谢!
推荐答案
有一个名为 VLOOKUP的函数您可能想要尝试.
There is a function called VLOOKUP that you might want to try.
您的示例的语法为:
=VLOOKUP(A1,'Worksheet2'.B1:C12,1)
这篇关于Libreoffice:通过FIND(),LOOKUP()或EXACT()引用另一个工作表中的单元格吗?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!