Lookup/Match Formula

I need a formula that looks up a certain value in a range and return a value in the corresponding row.

In Sheet 2 A1 I have VAN, in Sheet 1 row B I have varies cites, VAN, TOR, MTL, SAS.

The formula would need to look up any VAN Sheet 1 Row B and return the value in Row E.

For example if in Sheet 2 B4 I have VAN, then I need to return E4 to Sheet 2.

Now there are going to be many VAN's which is why a Vlookup wouldn't work, is there a way to return all the Column E cells that have a have VAN in Column B.

So on Sheet 2 it would look similar to this

VAN

1VANCLG1
1VANCLG2
1VANCLG3
1VANCLG4
1VANEDM1
1VANKEL1
1VANMTL1
1VANMTL1
1VANSAS1
1VANSAS2
1VANTOR1
1VANTOR2
1VANWPG1

So the formula would need to be in Sheet 2 Cells A2-A50