Combine two tables into one

[appsboss7]

Hi there,
I'm trying to combine 2 tables into 1.
The first table contains data about deliveries and the second contains data about serials.
I want to get a new table containing data from both tables, while joining the 2 tables by a column which both tables share called "orderCertificate".

* The Deliveries table contains many deliveries while each delivery has a unique orderCertificate, which can be attached to many records from the Serials.

An Example representing the 2 tables:
Deliveries:
Delivery1 | info about delivery1 | orderCertificate1
Delivery2 | info about delivery2 | orderCertificate2

Serials:
Item1 | info about item 1 | item1Serial | orderCertificate1
item2 | info about item 2 | item2Serial | orderCertificate1
item3 | info about item 3 | item3Serial | orderCertificate2


Is there any VBA function or a simple way to do that in excel?
I come from the SQL world and very rarely touched excel so if you could help me while explaining what I should change in order for things to work I will highly appreciate it!
Thanks in advance

{ If anyone has a solution for the problem in access it will also be great }

 

[etaf]

are these tables already in excel,

you could link to access or import into access and then "join" the two tables over the orderCertificate field and do a make table query

 

[appsboss7]

are these tables already in excel,

you could link to access or import into access and then "join" the two tables over the orderCertificate field and do a make table query

I already tried that, but since only 1 record from the first table is linked to multiple records from the second table, a simple join wouldn't work.

 

[etaf]

OK, in Excel then you can do a lookup
on the serials as they have multiple entries and in deliverys its only 1 per certificate

in Cell E2 of the Serials , and assuming the deliveries is on a deliveries sheet
=Index(A:A,Match(D2,$C:$C,0))
Copy into F2 and change to
=Index(B:B,Match(D2,$C:$C,0))

its years and years since i used Access to denormalise databases, extracting from SQL
But i remember doing that before OK in access, but been to long

Heres the example - in same sheet

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Serials:										Deliveries:
2	Item1	info about item 1	item1Serial	orderCertificate1	Delivery1	info about delivery1					Delivery1	info about delivery1	orderCertificate1
3	item2	info about item 2	item2Serial	orderCertificate1	Delivery1	info about delivery1					Delivery2	info about delivery2	orderCertificate2
4	item3	info about item 3	item3Serial	orderCertificate2	Delivery2	info about delivery2
5
6
Sheet1

Cell Formulas
Range	Formula
E2:E4	E2	=INDEX(K:K,MATCH(D2,M:M,0))
F2:F4	F2	=INDEX(L:L,MATCH(D2,M:M,0))