2
【笔记】Excl的数据查找函数
source link: https://feiju12138.github.io/2022/04/21/Excl%E7%9A%84%E6%95%B0%E6%8D%AE%E6%9F%A5%E6%89%BE%E5%87%BD%E6%95%B0/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Excl的VLOOKUP数据查找函数学习笔记
数据查找函数
查找值
:选择一个格子,格子内的内容表示想要搜索的关键字搜索范围
:选择一组格子,格子内的内容为搜索范围获取的列
:将搜索到的格子那一行的第几列作为当前格子的数据匹配条件
0
、True
:精确查找1
、False
:模糊查找
=VLOOKUP(查找值,搜索范围,获取的列,匹配条件);
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK