Sort a Table on two Columns with VBA

[AllisterB]

I need to be able to sort a Table on two Columns

This approach used a Full outer Join to Merge eth two tables. It worked for one column but I now need to look up on two Columns - What is the Price for Customer ABC at date X.

Can I use the same approach or is there another approach in PQ

Thanks

Allister

Effective Price.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M
6
7		Transactions							Price List
8		Date	Customer	Sales Value	Qty	Price			Effective	Customer	Price
9		1/04/2020	ABC	100.00	$ 20.00	5			1/04/2019	ABC	5
10		2/07/2020	DEF	3200.00	$ 320.00	10			30/04/2020	DEF	10
11		17/07/2020	ABC	20.00	$ 4.00	5			1/08/2020	ABC	12
12		31/07/2020	DEF	50.00	$ 5.00	10			17/08/2020	GHI	3
13		1/01/2021	GHI	30.00	$ 10.00	3			31/12/2021	ABC	11
14		17/01/2021	ABC	1100.00	$ 100.00	11
15
Sheet1

Cell Formulas
Range	Formula
F9:F14	F9	=[@[Sales Value]]/[@Price]