VLOOKUP Function

	A	B	C	D	F	G
1	Rank	Name	Industry	Revenue	Company	Industry
2	1	Walmart	Retail	$559,151	Walmart	Retail
3	2	State Grid	Electricity	$386,618	Amazon	Retail, Information Technology
4	3	Amazon	Retail, Information Technology	$386,064	Apple	Electronics
5	4	Apple	Electronics	$365,820	Microsoft	Information technology
6	5	China National Petroleum	Oil and gas	$283,958	Alphabet	Information technology
7	6	Sinopec Group	Oil and gas	$283,728
8	7	CVS Health	Healthcare	$268,706
9	8	UnitedHealth	Healthcare	$257,141
10	9	Toyota	Automotive	$256,722
11	10	Volkswagen	Automotive	$253,965
12	11	Berkshire Hathaway	Financials	$254,510
13	12	McKesson	Healthcare	$238,228
14	13	China State Construction	Construction	$234,425
15	14	Saudi Aramco	Oil and gas	$229,766
16	15	AmerisourceBergen	Healthcare	$213,990
17	16	Samsung Electronics	Electronics	$200,734
18	17	Ping An Insurance	Financials	$191,509
19	18	BP	Oil and gas	$183,500
20	19	Royal Dutch Shell	Oil and gas	$183,195
21	20	ICBC	Financials	$182,794
22	21	Alphabet	Information technology	$182,527
23	22	Foxconn	Electronics	$181,945
24	23	ExxonMobil	Oil and gas	$181,502
25	24	Daimler	Automotive	$175,827
26	25	China Construction Bank	Financials	$172,000
27	26	AT&T	Telecommunications	$171,760
28	27	Microsoft	Information technology	$168,090
29	28	Costco	Retail	$166,761
30	29	Cigna	Healthcare	$160,401
31	30	Agricultural Bank of China	Financials	$153,885
32	31	Cardinal Health	Healthcare	$152,922
33	32	Trafigura	Commodities	$146,994
34	33	China Life Insurance	Insurance	$144,589
35	34	Glencore	Commodities	$142,338
36	35	China Railway Engineering Corporation	Construction	$141,384
37	36	Walgreens Boots Alliance	Retail	$139,537
38	37	Exor	Holding company	$136,186
39	38	Allianz	Financials	$136,173
40	39	Bank of China	Financials	$134,046
41	40	Kroger	Retail	$132,498
42	41	Home Depot	Retail	$132,110
43	42	China Railway Construction	Construction	$131,992
44	43	JPMorgan Chase	Financials	$129,503
45	44	Huawei	Electronics	$129,184
46	45	Verizon	Telecommunications	$128,292
47	46	AXA	Financials	$128,011
48	47	Ford	Automotive	$127,144
49	48	Honda	Automotive	$124,241
50	49	General Motors	Automotive	$122,485
51	50	Anthem	Healthcare	$121,867
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100