I really need help in figuring out how to use the IF function and VLOOKUP together. All of these formulas need to be placed in the Order Form worksheet of my Excel workbook. I'd really appreciate anyone helping me set up the formulas and explaining the proper way to do these. I have attached my workbook.
This is the question in my Excel workbook that I am having trouble with:
In cell C17, insert an IF function that tests whether the value in cell B17 is equal to an empty text string (" "). If so, display an empty text string; otherwise, use the VLOOKUP function to look up the name of the item corresponding to the item ID in cell B17 in the Product_List table. Specify an exact match. Copy the formula in cell C17 to the range C18:C22.
In cell D17, insert an IF function that tests whether the value in cell C17 is equal to an empty text string. If so, display an empty text string, otherwise, use the VLOOKUP function to look up the price of the item in the Product_List table. Again, specify an exact match and copy the formula in Cell D17 to the range D18 : D22.
In cell F17, insert an IF function that tests whether the value in cell C17 is equal to an empty text string. If so, display an empty text string; otherwise, multiply the item price in cell D17 by the quantity in cell E17. Copy the formula in cell F17 to the range F18:F22.
|