explanations would be great. cheers

128 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 If you do not use absolute addressing ($I$129 instead of 1129) for the Table_array' and 'Range-lookup' parameters in the VLOOKUP function 126 the ranges will change when you copy down the formula. 127 Sales Regional Assignment 129 Cust 6 $ 250 North Cust 1 North 130 Cust 10 $ 750 West Cust 2 East 131 Cust 9 $ 858 East Cust 3 South 132 Cust 3 $ 807 South Cust 4 South 133 Cust 7 $ 475 Cust5 West 134 Cust 8 $ 716 Cust 6 North 135 Cust 7 $ 91 Cust 7 East 136 Cust 6 $ 58 Cust 8 East 137 Cust 10 $ 862 Cust 9 North 138 Cust 6 $ 488 Cust 10 West 139 Cust 3 $ 518 140 Cust 5 $ 232 141 Cust 4 $ 894 142 Cust 1 $ 784 143 Cust 1 $ 370 144 Cust5 $ 95 145 Cust5 $ 568 146 Cust 2 $ 498 147 Cust 10 $ 75 Cust 3 $ 187 149 Cust 7 $ 329 150 Cust 4 $ 361 151 Cust 6 $ 622 152 Cust 9 $ 148 153 Cust7 $ 493 154 Cust 9 $ 753 155 Cust 6 $ 966 Cust 8 $ 489 157 Cust 2 $ 968 158 Cust 6 $ 885 159 i su u 148 156