Vlookup

[Sefty]

Hello,

I need help, If I want to use vlookup but want to retrieve all the data if there is the same data, for example like the following example. If I use the regular vlookup formula it will only take the number "1" but I want to take the numbers "1" and "2" as in column D. Is there a formula that can help with this case?

Book1
	B	C	D		F	G	H
1		VLOOKUP(B2;G$2:H$7;2;FALSE)				source
2	16000	1	1			16000	1
3	16000	1	2			16000	2
4	17000	1	1			17000	1
5	17000	1	2			17000	2
6	18000	1	1			18000	1
7	18000	1	2			18000	2
8
9
Sheet1

Cell Formulas
Range	Formula
C2:C7	C2	=VLOOKUP(B2,L$2:M$7,2,FALSE)

 

[Fluff]

You cannot use vlookup for that, how about

=CHOOSEROWS(FILTER($H$2:$H$7,$G$2:$G$7,B2),COUNTIFS(B$2:B2,B2))