Can Vlookup deliver multiple responses from a column?

[jpxlhelp]

Hi, i'm a novice user of XL, but frequently use a vlookup formula when comparing my workbooks. I'm struggling to sort through my worksheets and am needing to show the contents of EACH of the cells that corelate to a specific cell.

For example:

Individual ID	Fruit
1	Banana
2	Apple
1	Kiwi

My spreadsheet is about 1000x rows, so sorting by each individual ID is not a preferred option. How else can I have a list of the IDs but pull each of the fruit that correlate to that individual ID?

 

[alansidman]

Your example is not sufficient to offer up a specific solution. However, if I am understanding you correctly then you will want to use the merge query (table/range) functions within Power Query which is found on the Data Tab of the Ribbon and referred to as Get and Transform Data.

 

[AhoyNC]

Maybe use the FILTER function.

Book2
	A	B	C	D	E	F
1	Individual ID	Fruit		ID	1	2
2	1	Banana			Banana	Apple
3	2	Apple			Kiwi
4	1	Kiwi
Sheet1

Cell Formulas
Range	Formula
E2:E3,F2	E2	=FILTER($B$2:$B$4,$A$2:$A$4=E$1)
Dynamic array formulas.