123 108 109 Compiling Data From Desperate Sources 110 Let's see how a VLOOKUP can be used to combine data from multiple tables. 111 The 'Sales' table below lists for each of last week's sales the customer and dollar value. 112 The 'Regional Assignment' table shows the region to which each customer has been assigned. 113 In the Sales table below, write a formula in B120 that uses the VLOOKUP function to lookup the Regional Assignment of the related customer in C120. 114 Use the VLOOKUP function pop-up window to guide you through the creation of the statement. 115 In the Sales table below, copy down the formula in B120 to lookup the Regional Assignment of the related customer in each row. 116 If you do not use absolute addressing ($I$120 instead of 1120) for the 'Table_array' and 'Range-lookup' parameters in the VLOOKUP function 117 the ranges will change when you copy down the formula. 118 119 Sales Regional Assignment 120 Cust 6 $ 250 North Cust 1 North 121 Cust 10 $ 750 West Cust 2 East 122 Cust 9 $ 858 East Cust 3 South Cust 3 $ 807 South Cust 4 South 124 Cust7 $ 475 Cust 5 West 125 Cust 8 $ 716 Cust 6 North 126 Cust7 $ 91 Cust7 East 127 Cust 6 $ 58 Cust 8 East 128 Cust 10 $ 862 Cust 9 North 129 Cust 6 $ 488 Cust 10 West Cust 3 $ 518 131 Cust 5 $ 232 132 $ 894 133 Cust 1 $ 784 134 Cust 1 $ 370 135 Cust5 $ 95 136 Cust 5 $ 568 137 Cust 2 $ 498 138 Cust 10 $ 75 139 Cust3 $ 187 140 Cust 7 $ 329 Cust 4 $ 361 142 Cust 6 $ 622 143 Cust 9 $ 148 144 Cust7 $ 493 145 Cust 9 $ 753 146 Cust 6 $ 966 147 Cust 8 $ 489 148 Cust 2 $ 968 149 Cust 6 $ 885 150 130 Cust 4 141 123 108 109 Compiling Data From Desperate Sources 110 Let's see how a VLOOKUP can be used to combine data from multiple tables. 111 The 'Sales' table below lists for each of last week's sales the customer and dollar value. 112 The 'Regional Assignment' table shows the region to which each customer has been assigned. 113 In the Sales table below, write a formula in B120 that uses the VLOOKUP function to lookup the Regional Assignment of the related customer in C120. 114 Use the VLOOKUP function pop-up window to guide you through the creation of the statement. 115 In the Sales table below, copy down the formula in B120 to lookup the Regional Assignment of the related customer in each row. 116 If you do not use absolute addressing ($I$120 instead of 1120) for the 'Table_array' and 'Range-lookup' parameters in the VLOOKUP function 117 the ranges will change when you copy down the formula. 118 119 Sales Regional Assignment 120 Cust 6 $ 250 North Cust 1 North 121 Cust 10 $ 750 West Cust 2 East 122 Cust 9 $ 858 East Cust 3 South Cust 3 $ 807 South Cust 4 South 124 Cust7 $ 475 Cust 5 West 125 Cust 8 $ 716 Cust 6 North 126 Cust7 $ 91 Cust7 East 127 Cust 6 $ 58 Cust 8 East 128 Cust 10 $ 862 Cust 9 North 129 Cust 6 $ 488 Cust 10 West Cust 3 $ 518 131 Cust 5 $ 232 132 $ 894 133 Cust 1 $ 784 134 Cust 1 $ 370 135 Cust5 $ 95 136 Cust 5 $ 568 137 Cust 2 $ 498 138 Cust 10 $ 75 139 Cust3 $ 187 140 Cust 7 $ 329 Cust 4 $ 361 142 Cust 6 $ 622 143 Cust 9 $ 148 144 Cust7 $ 493 145 Cust 9 $ 753 146 Cust 6 $ 966 147 Cust 8 $ 489 148 Cust 2 $ 968 149 Cust 6 $ 885 150 130 Cust 4 141
