下拉列表中的Excel VLookUP [英] Excel VLookUP on drop down list

问题描述

我在Excel中有两张纸，即提交"和验证".在我的验证表上，我有两个信息来源.G列包含我的社区名称，即列表中的内容.H列保存我的NumberCode，这是我要自动填充的内容.

I have two sheets in excel, Submission and Validation. On my Validation Sheet I have my two sources of information. Column G holds my community names, the thing in my list. Column H holds my NumberCode, the thing I want to auto populate.

示例验证:

G       H
Venice  26423
Scarborough 24741

在我的提交表上，我有一个数据验证下拉列表.其信息是:

On my Submission sheet I have a data validation drop down list. whose information is:

我正在尝试查找代码，以便当我的下拉列表中有Venice时，它旁边的单元格应自动填充26423.我对Vlookup代码的最新迭代是:

I am trying to lookup the codes so that when my dropdown list has Venice, the cell next to it should auto-populate 26423. My latest iteration of the Vlookup code is:

=VLOOKUP('Validation Page'!G1:G1067,'Validation Page'!H1:H1067,,FALSE)

我尝试将其放入表中，放入名称引用中，等等，但是似乎什么也不想填充.我收到#N/A或其他错误.有帮助吗?

I have tried putting it into tables, putting it into name reference, ect but nothing seems to want to populate. I either get #N/A or another error. Any help?

推荐答案

尝试将其放入您需要填充的单元格hat中，并使用数字代码

try puting this in the cell tahat you need populate with the number code

=VLOOKUP('Submission Page'!G1,'Validation Page'!G1:H1067,2,FALSE)

为下拉列表所在的正确单元格更改提交页面"！G1

change 'Submission Page'!G1 for the correct cell where the drop down list is

这篇关于下拉列表中的Excel VLookUP的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！