vlookup return multiple values
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
VLOOKUP to return multiple values
2
Created by Ben Collins
3
Read more at:
https://www.benlcollins.com/formula-examples/vlookup-return-multiple-columns/
4
5
Feel free to make your own copy so you have editing rights.
6
File > Make a copy...
7
8
9
Transaction IDPayment DateProductQuantityCostRevenueSales Channel
10
MVLN1951/3/2014Trash Can1$14.00$14.00Affiliate
11
XFYR2461/4/2014Lawnmower1$599.00$599.00Twitter
12
DWDF1671/4/2014Diapers1$29.00$29.00Google ads
13
YNBM3391/5/2014Sweater3$59.00$177.00Email list
14
WTKQ7581/7/2014Bike1$599.00$599.00Banner ads
15
SFKS5271/7/2014Radio1$25.00$25.00Direct traffic
16
OGWT2881/8/2014Bike1$599.00$599.00Email list
17
TCQN5161/9/2014Calender5$3.00$15.00Direct traffic
18
19
20
Return multiple results with single VLOOKUP
21
22
Search term
Payment Date
ProductRevenue
Sales Channel
23
OGWT2881/8/2014Bike$599.00Email list
24
25
26
Return multiple results with single VLOOKUP - VERTICAL ORIENTATION
27
28
Search termOGWT288
29
Payment Date
1/8/2014
30
ProductBike
31
Revenue599
32
Sales Channel
Email list
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
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
Loading...
Main menu