Here 'sa quick tutorial for those who need help using the VLOOKUP function in Excel.

这里的快速指南，为那些需要帮助，谁使用vlookup函数在。

youdao

You also can use the names in column a as the Source range for a list in another cell by selecting Data Validation list. Then reference the cell housing this list in your VLOOKUP function.

我们也可以把A列中的名字做为另一单元格数据有效性序列的源区域，然后在VLOOKUP函数中引用这个单元格。

youdao