Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Creating a new worksheet and using VLOOKUP: a. Copy the data from the Products worksheet to a new worksheet named: Vlookup i) Note: See step

image text in transcribed
image text in transcribed
Creating a new worksheet and using VLOOKUP: a. Copy the data from the Products worksheet to a new worksheet named: Vlookup i) Note: See step 38 for information on how to copy data from one worksheet to another b. Enter the following text i) In cell G1: Handling Fee ii) In cell A12: Category iii) In cell A13: AT iv) In cell A14:DE v) In cell A15: MD vi) In cell A16: WD vii) In cell B12: Handling Fee in Dollars viii) In cell B13:0 ix) In cell B14:2 x) In cell B15:5 xi) In cell B16: 10 c. AutoFit the column width for column G d. In cell G2, insert a VLOOKUP function that determines the correct handling fee as follows: d. In cell G2, insert a VLOOKUP function that determines the correct handling fee as follows: i) The function will refer to the Lookup_value in C2 ii) The function with use the Table_array A12 : B16 (though it will need to be absoluted so that each row will reference the same table array once it's copied) iii) The function will take the value from the table array from column 2 iv) The function must contain a Range_lookup of FALSE so that the categories are identical matches between the table array and the main data (if not, AT could be matched in more than one place... ask your instructor to explain this) e. Use the fill handle to copy this formula down to row 7. f. Format G2: G7 to Currency Number Format with 2 decimal places

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

=+What can we learn about the PVA data from this decision tree?

Answered: 1 week ago