need explanations. cheers

Saws 4 3 1 2 5 West East ON 6 12 8 13 9 12 14 242 Sales Volume 243 Screwdrivers Drills 244 North 245 246 247 South 248 249 We will use the MATCH and INDEX functions to determine how many 'Drills' were sold in the 'East' region. 250 These two functions are often used together to determine the horizontal and vertical offsets (relative positions of the targeted value 251 and then these offsets are used in the INDEX function to select the value. 252 Write a formula in the green cell immediately below that uses the MATCH function to select the relative position of "East' in the range B244:B247. 253 254 Use the MATCH function pop-up window to guide you through the creation of the statement. 255 Since you are searching for an exact match to 'East' the third parameter in the function should be 'FALSE'. 256 Write a formula in the green cell immediately that uses the MATCH function to select the relative position of 'Drills' in the range C243:E243. 257 258 259 260 Use the MATCH function pop-up window to guide you through the creation of the statement. Since you are searching for an exact match to Drills' the third parameter in the function should be "FALSE