Excel/Google驱动器中的vlookup [英] vlookup in excel/google drive

问题描述

对不起，这是一个非常基本的问题，但由于某种原因，它只是在使我难以理解.

Im sorry this is a very basic question but for some reason it's just eluding me.

我正在尝试在表中执行VLOOKUP，而在尝试查找字符串值时却不断收到错误消息.

I'm trying to do a VLOOKUP in a table and I keep getting an error when trying to look up a string value.

我在Google云端硬盘上创建了问题，以帮助说明我的意思 https://docs.google.com/spreadsheets/d/1L70yQeWN8KYQeWa11 ?usp =分享

I have created the problem on google drive to help illustrate what i mean https://docs.google.com/spreadsheets/d/1L70yQeWmr0J08UwK3nkSQaLNVFzfI1zi8euzhoYq8XY/edit?usp=sharing

致谢

推荐答案

索引/ MATCH 函数对.

The VLOOKUP function is intended to return a value that is to the right of the look up value. To reverse this, use a INDEX/MATCH function pair.

=index(A:A, match("Danton", B:B, 0))

顺便说一句，如果在 range_lookup 参数中使用TRUE(或省略)，则需要对查阅列进行排序.

btw, if you use TRUE (or omit) in the range_lookup parameter, the lookup column needs to be sorted.

这篇关于Excel/Google驱动器中的vlookup的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！