Need to Pull multiple rows from table using the same Primary Key

[mxcoop98]

I've tried searching but I can't figure out the best approach. I want to figure out how to dynamically fill in a receipt template by changing the order number value and having the data filled in in the order detail on the receipt. I've tried vlookup but it only pulls the first row with that Order ID

The data that it's being pulled from could have multiple rows with the same order ID. The way I have the formula now works great, except if there are multiple orders with the same amount of rows because it matches row numbers instead of matching by the order ID.

Anyway, i'm sure it's simple but i'm stumped, any help would be greatly appreciated. I attached the file i'm working with.

Sales receipt1.xlsx

[protonLeah]

I changed the column headers on sheet1 to correspond to the sales receipt headers. Then:
A17:

Please Login or Register  to view this content.

It looks for the matching column header, then goes down to matching receipt number adjusted by row (i.e. the first line item on the receipt is in row 17, so the adjustment, ROW()-17 is zero rows from the sheet1 match.