类似于VLOOKUP的函数
来源:学生作业帮 编辑:搜搜考试网作业帮 分类:综合作业 时间:2024/08/02 18:18:21
类似于VLOOKUP的函数
有没有类似于Vlookup的函数,假如在一个表中第一列有A,并且A出现了很多次,相对应的A在第二列都会对应一个不同的数值,也就是说在第一列会有很多A,而在第二列A所对应的数值都不一样,现在用什么函数可以通过查找第一列A的方法找出所有第二列A所对应的所有不同的数值?例如下面给出的查出D01253多对应的所有第2列的数值,但是用Vlookup只能查出其中一个数值.
D01253 JUVENILE PRODUCTS
D01253 KITCHEN UTENSILS - PLASTICWARE
D01253 JUVENILE PRODUCTS
D01253 KITCHEN UTENSILS - PLASTICWARE
D01253 JUVENILE PRODUCTS
D01253 SHOES
D01253 SHOES
D01253 JUVENILE PRODUCTS
D01253 SHOES
D01253 KITCHEN UTENSILS - PLASTICWARE
D01253 JUVENILE PRODUCTS
D01253 KITCHEN UTENSILS - PLASTICWARE
D01253 JUVENILE PRODUCTS
D01253 SHOES
D01253 JUVENILE PRODUCTS
D01253 KITCHEN UTENSILS - PLASTICWARE
D01253 JUVENILE PRODUCTS
D01253 SHOES
D01253 JUVENILE PRODUCTS
D01253 SHOES
D01253 JUVENILE PRODUCTS
D01253 KITCHEN UTENSILS - PLASTICWARE
D01253 JUVENILE PRODUCTS
D01253 SHOES
有没有类似于Vlookup的函数,假如在一个表中第一列有A,并且A出现了很多次,相对应的A在第二列都会对应一个不同的数值,也就是说在第一列会有很多A,而在第二列A所对应的数值都不一样,现在用什么函数可以通过查找第一列A的方法找出所有第二列A所对应的所有不同的数值?例如下面给出的查出D01253多对应的所有第2列的数值,但是用Vlookup只能查出其中一个数值.
D01253 JUVENILE PRODUCTS
D01253 KITCHEN UTENSILS - PLASTICWARE
D01253 JUVENILE PRODUCTS
D01253 KITCHEN UTENSILS - PLASTICWARE
D01253 JUVENILE PRODUCTS
D01253 SHOES
D01253 SHOES
D01253 JUVENILE PRODUCTS
D01253 SHOES
D01253 KITCHEN UTENSILS - PLASTICWARE
D01253 JUVENILE PRODUCTS
D01253 KITCHEN UTENSILS - PLASTICWARE
D01253 JUVENILE PRODUCTS
D01253 SHOES
D01253 JUVENILE PRODUCTS
D01253 KITCHEN UTENSILS - PLASTICWARE
D01253 JUVENILE PRODUCTS
D01253 SHOES
D01253 JUVENILE PRODUCTS
D01253 SHOES
D01253 JUVENILE PRODUCTS
D01253 KITCHEN UTENSILS - PLASTICWARE
D01253 JUVENILE PRODUCTS
D01253 SHOES
![类似于VLOOKUP的函数](/uploads/image/z/17916866-26-6.jpg?t=%E7%B1%BB%E4%BC%BC%E4%BA%8EVLOOKUP%E7%9A%84%E5%87%BD%E6%95%B0)
用数组全部找出来,加上SMALL函数,你想打其中的第几个就第几个