Displaying multiple rows

[covershaker]

I need help pulling multiple rows from a table. See my table structure below.

Sheet 1

lookup = 300500


Sheet 2

Column A Column B
300499 405222
300499 405223
300500 405333
300500 405332
300500 405331

[AlKey]

You can use this formula to get values from column B if they match criteria in column A.

=IFERROR(INDEX(B:B,SMALL(INDEX(($A$2:$B$100<>$D$2)*10^10+ROW($A$2:$B$100),0),ROWS($E$2:$E2))),"")

Row\Col	A	B	C	D	E
1	Col1	Col2		loockup value	Reslults
2	300499	405222		300500	405333
3	300499	405223			405332
4	300500	405333			405331
5	300500	405332
6	300500	405331