vlookup 多次返回excel [英] vlookup multiple returns excel

问题描述

我正在处理当地大学学生信息的数据集.

I am working with a data set of students information at a local university.

我使用了 VLOOKUP，使用学生的 ID 作为唯一标识符.但我的问题是，VLOOKUP 只需要一行信息，研究中一半的学生每行超过 5 行.如何让 EXCEL 返回多行?

I used a VLOOKUP, using the IDs of the students as the unique identifier. But my problem is that the VLOOKUP only requires one row of information and half of the students in the study have more than 5 lines each. How can I make EXCEL return multiple lines?

推荐答案

VLookup 将根据最后一个布尔函数参数返回匹配或紧密匹配条件的第一行.假设该 ID 是唯一的，并且在您要搜索的表中没有重复多次.

VLookup will return the first row matching or closely matching the condition depending on the last boolean function parameter. It is assumed that the ID is unique and not repeated several times in the table you are searching in.

据我了解这个问题，要么你找到一种方法来为查找表创建一个唯一的键，这样一个键看起来像'ID +另一列'，以一种独特的方式格式化，比如'ID - 其他ID'或您将不得不使用 VBA 来检索匹配某个非唯一条件的所有行.

As far as I understand the issue, either you find a way to make a unique key for the lookup table so a key loking like 'ID + another column' formatted in a unique way such as 'ID - Other ID' or you will have to use VBA to retrieve all the rows matching a certain non unique condition.

如果手头的工作很小，或者无法考虑 VBA，可以使用自动过滤器手动解决它来进行匹配/检索可能会有所帮助.

If the job at hand is small, or VBA cannot be considered, and it is acceptable to work it out manually using auto Filters to do the matching/retrieving could help.

这篇关于vlookup 多次返回excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！