VBA VLOOKUP from multiple columns

[Neveidas]

Hi guys, I'm trying to VLOOKUP from multiple columns, so I would need to VLOOKUP Column A referencing Column H and I, and have the location placed in Column C. But it would also need to look up at Column B and if the name of the company is "OPPO Company", then Column C's value would be OPPO-FLEET, it also needs to look up Column D and if it's "Forward to shipping partner", then Column C's value will be "Cross-Border Export"

Sorry if it sounds messy, I hope I explained it right

Main Template.xlsm
	A	B	C	D	E	F	G	H	I
1	postal code		Location	Status				Postcode	Pickup Hub
2	53	ABC Company	CSL	Delivered				01	PJ
3	54	ABC Company	CSL	Delivered				02	PJ
4	56	ABC Company	CSL	Delivered				03	PJ
5	82	ABC Company	CSL	Delivered				04	PJ
6	52	ABC Company	CSL	Delivered				05	PJ
7	65	ABC Company		Delivered				06	PJ
8	82	ABC Company		Delivered				07	PJ
9	32	ABC Company		Delivered				08	PJ
10	64	ABC Company		Delivered				09	PJ
11	82	ABC Company		Delivered				10	PJ
12	46	ABC Company		Delivered				11	PJ
13	79	ABC Company		Delivered				12	PJ
14	L8	ABC Company	Cross-Border Export	Forward to Shipping Partner				13	PJ
15	88	ABC Company	Cross-Border Export	Forward to Shipping Partner				14	PJ
16	85	ABC Company	Cross-Border Export	Forward to Shipping Partner				15	PJ
17	98	ABC Company	Cross-Border Export	Forward to Shipping Partner				16	PJ
18	88	ABC Company	Cross-Border Export	Forward to Shipping Partner				17	PJ
19	83	ABC Company	Cross-Border Export	Forward to Shipping Partner				18	PJ
20	HK	XYZ Company	Cross-Border Export	Forward to Shipping Partner				19	PJ
21	85	XYZ Company	Cross-Border Export	Forward to Shipping Partner				20	PJ
22	Ta	XYZ Company		Forward to Shipping Partner				21	PJ
23	96	XYZ Company		Forward to Shipping Partner				22	PJ
24	86	XYZ Company		Forward to Shipping Partner				23	PJ
25	86	XYZ Company		Forward to Shipping Partner				24	PJ
26	87	XYZ Company		Forward to Shipping Partner				25	PJ
27	88	XYZ Company		Forward to Shipping Partner				26	PJ
28	53	OPPO Company	OPPO-FLEET	Delivered				27	PJ
29	54	OPPO Company	OPPO-FLEET	Delivered				28	PJ
30	56	OPPO Company	OPPO-FLEET	Delivered				29	PJ
31	82	OPPO Company	OPPO-FLEET	Delivered				30	PJ
32	52	OPPO Company	OPPO-FLEET	Delivered				31	PJ
33	65	OPPO Company	OPPO-FLEET	Delivered				32	PJ
34	82	OPPO Company	OPPO-FLEET	Delivered				33	CSL
35	32	OPPO Company		Delivered				34	CSL
36	64	OPPO Company		Delivered				35	PJ
37								36	CSL
38								37	CSL
39								38	CSL
40								39	CSL
41								40	CSL
42								41	CSL
43								42	CSL
44								43	CSL
45								44	CSL
46								45	CSL
47								46	CSL
48								47	CSL
49								48	CSL
50								49	CSL
51								50	CSL
52								51	CSL
53								52	CSL
54								53	CSL
55								54	CSL
56								55	CSL
57								56	CSL
58								57	PJ
59								58	PJ
60								59	PJ
61								60	PJ
62								61	PJ
63								62	PJ
64								63	PJ
65								64	PJ
66								65	PJ
67								66	PJ
68								67	PJ
69								68	PJ
70								69	PJ
71								70	PJ
72								71	PJ
73								72	PJ
74								73	PJ
75								75	PJ
76								76	PJ
77								77	PJ
78								78	PJ
79								79	CSL
80								80	CSL
81								81	CSL
82								82	CSL
Sheet3

 

[Neveidas]

There is no formula in C2:C13?
Just copy C14 up to first row C2.

yup, i just realised it too, thank you so so much, it is working as intended now

 

[Neveidas]

There is no formula in C2:C13?
Just copy C14 up to first

It wasn't working as intended because of a Typo at the end, should be "VLOOKUP(LEFT(A2 instead of B2 right?

 

[bebo021999]

Thats right, my apologize.
Nice to hear it works.