Hi, i have a table that looks as follows:

CUSTID CUSTNAME ADDRESS
123 customer1 The street
345 customer2 The road


And I have another table that looks as follows

CUSTID PRODUCT VOLUME
123 z-Units 13
123 a-units 25
345 z-units 10
345 b-units 5
123 b-units 12


And I need and output table that loos as follows:

CUSTID CUSTNAME ADDRESS PRODUCT VOLUME
123 customer1 The street z-units 13
123 customer1 The street a-units 25
123 customer1 The street b-units 12
345 customer2 The road z-units 10
345 customer2 The road b-units 5


I have try to do this with VLOOKUP, and also with a combination of OFFSET
and MATCH, but I always get an N/A. As tbale 1 and table 2 can have variable
lenghts, I wonder what can I do.