Vlookup formula help

Dina B

Hello -

I created a summary sheet using the vlookup formula referencing another sheet. However, how do I show two amounts from two different rows in the source sheet where one row is the parent and one row is the child? I got it to show one of the values (the one from the PARENT row), but I need it to show both amounts in my summary sheet, as items of the same lot were shipped at different times. Thank you in advance!

Matt Lynn-PCG

@Dina B it would help to see a screenshot. As a general rule I never use vlookup personally. It works but has risks. I'd prefer to use a =index(collect()) or some other version of a collect(). I'd like to see but you may need a join(collect()).

Dina B

@Matt Lynn-PCG

Above is my source sheet. Below is my summary sheet where I wanted a column showing the two amounts per lot number.

Also, I haven't heard of =index(collect) before.