Knowee
Questions
Features
Study Tools

Enter a formula in cell B2 using the VLOOKUP function to find the total sales for the date in cell B1. Use the name DailySales for the lookup table. The total sales are located in column 5 of the lookup table. Be sure to require an exact match.

Question

Enter a formula in cell B2 using the VLOOKUP function to find the total sales for the date in cell B1. Use the name DailySales for the lookup table. The total sales are located in column 5 of the lookup table. Be sure to require an exact match.

🧐 Not the exact question you are looking for?Go ask a question

Solution

Sure, here is the step by step guide to enter the formula:

  1. Click on cell B2 to make it active. This is where you want the result to appear.

  2. Type the equals sign (=) to begin the formula.

  3. Type "VLOOKUP(" without the quotes. This is the function you will use.

  4. Click on cell B1. This is the date you want to look up. The cell reference B1 will appear in your formula.

  5. Type a comma (,) to separate the arguments.

  6. Type "DailySales" without the quotes. This is the name of the lookup table.

  7. Type another comma (,) to separate the arguments.

  8. Type the number 5. This is the column in the lookup table where the total sales are located.

  9. Type another comma (,) to separate the arguments.

  10. Type "FALSE" without the quotes. This requires an exact match.

  11. Type a closing parenthesis ()) to end the function.

  12. Press Enter to complete the formula.

The final formula should look like this: =VLOOKUP(B1, DailySales, 5, FALSE)

This problem has been solved

Similar Questions

Identify the correct Lookup formula =LOOKUP(b2,Sales,2,0) HLOOKUP(b2,Sales,2,0) =VLOOKUP(b2,Sales,2,0) None of the above

Sophie is working on an order and wishes to calculate the total price for the order. She first needs to look up the prices for each item in the order, given the product name and price data. What function would she write in cell E2 to obtain this information without doing it manually?0 / 1 point=VLOOKUP(D3,$A$2:$B$12,3,FALSE)=VLOOKUP(E2,$A$1:$C$20,2,FALSE)=VLOOKUP(A2,$A$2:$B$12,3,FALSE)=VLOOKUP(D2,$A$2:$B$12,2,FALSE)

You are a marketing analyst for a retail company. The company maintains a database of customer transactions such as customer IDs, product names, and quantities purchased. Your task is to determine the total quantity of a specific product sold to a particular customer. Which of the following formulas correctly uses the VLOOKUP function to retrieve the quantity of "Product X" sold to Customer ID 121?Options :=VLOOKUP(121, A2:C100, 3, 1)=VLOOKUP("Product X", A2:C100, 2, 0)=VLOOKUP(121, A2:C100, 2, 0)=VLOOKUP(121, A2:C100, 1, 0)

Question 3You are working on the sales data for office desks and want to calculate the total profits for the year 2020. What function would you use to calculate the total profits, which are located in the cell range B2 to B220?1 point= TOTAL (B2 : B220)= B2 + B220= B2 : B220= SUM ( B2 : B220)

ou have an Excel file of 50 orders placed by customers. There are three columns:Column A stores whether a customer is a repeat customer or not. It can only be Yes or NoColumn B stores whether an order was placed on a weekend. It can also only be Yes or NoColumn C stores the order amountWhich of the following is best suited to calculate: the total order amount placed by all repeat customers on a weekend?SUMSUMIFIFSUMSUMIFS

1/2

Upgrade your grade with Knowee

Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.