Does vlookup return with multiple value?

Excel sheet 1 have data in column A as Airwaybill number
Excel sheet 2 have data in column A as Airwaybill number and in column B
Order number.

E.g.
Excel 1
Airwaybill number
1
2
3

Excel 2
Airwaybill number Order number
1 1
2
3
4
5
2 1
2
3
4

But in a single Airwaybill number, there are multiple order number.
Normally when vlookup, the return value is always single value and/or the
first row of the airways. In what way can i have vlookup to reflect the
multiple order number of the single airwaybill number? Or is there any
function in Excel that can be use to perform this?

Any advice will be greatly appreciate.
Thank you.