Look up a value and pull back the matching detail, like finding a price from a product code.
What Is the Price of Product 204?
A company maintains a catalog listing each product’s code, name, price, and stock. A customer has ordered product code 204. What is the correct price to charge for this product? Requirements: Your formula must use the VLOOKUP function to find the correct price.
What Were the Expenses for March?
A shop tracks its finances with each month’s figures in separate columns. The top row lists the months, and the two rows beneath show money in (sales) and money out (costs). What is the value for costs (money out) in March? Requirements: Your formula must use the HLOOKUP function to find the correct answer.
Which Product Is Barcode 5007?
A warehouse tracks inventory by scanning barcodes. In the table, product names are listed in the first column, and barcodes in the last. If a scanner reads barcode 5007, which product does it correspond to? Requirements: Your formula must use the XLOOKUP function to find the correct product.
What Is the Monthly Fee for Member 4071?
A gym maintains a list of members, with columns for ID, name, monthly fee, and last month’s visits. The front desk needs to find the monthly fee for member ID 4071. What is the correct fee for this member? Requirements: Your formula must use the INDEX and MATCH functions to find the answer.
Who Used Card Number 8804?
Gym members scan an entry card to enter; the card number is in the column on the right, and the member’s name is on the left. Card number 8804 was used. Whose name is it? Requirements: You can either use INDEX and MATCH or XLOOKUP for this problem.
What Is the Price Difference Between Items 5007 and 5004?
A warehouse tracks products by scanning barcodes. In the table, barcodes are listed in the rightmost column, and prices are in the column directly to the left. What is the difference in price between the item with barcode 5007 and the item with barcode 5004? Requirements: Your formula must use only the XLOOKUP function.
What Is the Unit Price for an Order of 120 Units?
A wholesaler offers a lower price per item when you buy more. The table shows how many units you need to get each price. If you order a number between two numbers in the table, use the price of the smaller number. If a customer orders 120 units, what is the unit price for this order? Requirements: Your formula must use only the VLOOKUP function.
How Many People Joined the Spin Class on Thursday?
A gym records how many people joined each class every day of the week. Class names are listed down the left, and days of the week are shown across the top. How many people attended the Spin class on Thursday? Requirements: Use only INDEX and MATCH functions in your formula.