Vlookup consecutive matches

Below is similar to the table I am using. I need to lookup both LOT and VAR and return a PAL and then in the next cell I need to lookup what the next match is. So the return table is kinda like a summary of the LOT + VAR listing all the PAL matches in separate cells. Any idea how to construct such a lookup?

Lookup

Lot	Var	Pal
BP18001	BLB 12X6	029
AG18001	BLB 12X6	001
BP18001	BLB 12X6	027
HS18001	BLB 12X6	002
BP18001	BLB 1P	023

RETURN

BP18001 BLB 12X6

029

027