Which Logical value do you enter in the Range_lookup

function to find an EXACT match?

Which symbol is applied to ‘lock in’ values in the VLookup function?

Once you have done the following:

1. Add the data table provided ('mean time until

failure and the standard deviation by department') ,

2. Place it in the VLOOKUP

Function arguments under ‘Table_array’

3. Place B2 as the Lookup_value. 

Which department will you be checking?

How many customers are eligible for the $20 Discount Voucher?

What

is the total number of “Regular” customers?

How many customers are eligible for the new $30 Discount Voucher (Promotional Voucher)?

How many customers are NOT eligible for any type of discount voucher?