Answered step by step
Verified Expert Solution
Question
1 Approved Answer
118 Compiling Data From Desperate Sources 119 Let's see how a VLOOKUP can be used to combine data from multiple tables. 120 The 'Sales' table
118 Compiling Data From Desperate Sources 119 Let's see how a VLOOKUP can be used to combine data from multiple tables. 120 The 'Sales' table below lists for each of last week's sales the customer and dollar value. 121 The 'Regional Assignment' table shows the region to which each customer has been assigned. 122 In the Sales table below, write a formula in B129 that uses the VLOOKUP function to lookup the Regional Assignment of the related customer in C129. 123 Use the VLOOKUP function pop-up window to guide you through the creation of the statement. 124 In the Sales table below, copy down the formula in B129 to lookup the Regional Assignment of the related customer in each row. 125 126 If you do not use absolute addressing ($I$129 instead of 1129) for the 'Table_array' and 'Range-lookup' parameters in the VLOOKUP function the ranges will change when you copy down the formula. 127 128 129 Sales Cust 6 $ 250 North 130 Cust 10 $ 750 West 131 Cust 9 $ 858 East 132 Cust 3 $ 807 South 133 Cust 7 $ 475 134 Cust 8 $ 716 135 Cust 7 $ 91 136 Cust 6 $ 58 137 Cust 10 $ 862 138 Cust 6 $ 488 Regional Assignment Cust 1 North Cust 2 East Cust 3 South Cust 4 South Cust 5 West Cust 6 North Cust 7 East Cust 8 East Cust 9 North Cust 10 West 139 Cust 3 $ 518 140 Cust 5 $ 232 141 Cust 4 $ 894 142 Cust 1 $ 784 143 Cust 1 $ 370 144 Cust 5 $ 95 145 Cust 5 $ 568 146 Cust 2 $ 498 147 Cust 10 $ 75 148 Cust 3 $ 187 149 Cust 7 $ 329 150 Cust 4 $ 361 151 Cust 6 $ 622 152 Cust 9 $ 148 153 Cust 7 $ 493 154 Cust 9 $ 753 155 Cust 6 $ 966 156 Cust 8 $ 489 157 Cust 2 $ 968 158 Cust 6 $ 885 159
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started