Vlookup ( sort of ) - pulling multiple items

[spcalan]

I want to create a nice dashboard ( without VBA )..

On Sheet 1 :
I have a cell that I type in a SKU ( RMGF9365 )....
I have 10 empty cells ( that will be filled in wirth data from sheet 2 )..

So example :
I want to know what batches are in inventory from sheet 2...

So if RMGF9365 has 5 batches.. pull those 5 batches into Sheet 1.. to a maximum of 10....

Thoughts ?
Can this be done without VBA ?

I can go back and pull some vba that matches, then copies,pastes into sheet 1.. but would rather not go that route..