Question: Click cell C 9 , and insert a VLOOKUP function that looks up the code in cell B 9 , compares it to the codes

Click cell C9, and insert a VLOOKUP function that looks up the code in cell B9, compares it to the codes and types of art in the range B2:C6, and returns the type of art. Copy the function in cell C9 to the range C9:C5. Hide column B that contains the codes.
Click cell C9, and insert a VLOOKUP function that looks up

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Excel project due Friday please help EXP E Capstone 1 - European Excursions 2.5 Project Description: You work for a travel company that specializes in arranging travel accommodations for student...

Q:

Base Price Commission Package Tour Description Departure Base Cost $1,699 2.5% 10 Adventures in Canada 2016/6/11 $1,699.00 $1,749 3.0% 20 Check Out the Czech Republic! 2016/6/4 $1,799.00 $1,799 3.5%...

Q:

Kindly make an excel sheet of below enteries On the Payment Table sheet, in cell B9, enter rates in decrements of .5% beginning with 9.00% and ending with 5.50% in cell B16. Format rates with two...

Q:

2. Insert today?s date into cell H2. Format it to display in dd/mm/yyyy format.3. Display the Payment Table sheet. Enter rates in decrements of 0.5% beginning with9.00% in cell B9 and ending with...

Q:

how to i sert a vlookup function that looks up the code in cell b 1 1 , compares it to the codes and types of art in the range b 2 :c 6 and returns the type of art. use relative and mixed references...

Q:

File Home Insert Page Layout Formulas Data Review View Help Share Com X - General 29 0 TO - . Format Calbei BIU Paste 2 Wrap Test 2. Merge Center $ % 92 Conditional Format Cell Formatting Table...

Q:

A. Click cell E13 and insert a lookup function that looks up the tour code, compares it to the tours table, and returns the departure date. Copy the function down through cell E22. B. Click cell F13...

Q:

Excel Chapter 7-Real Estate Exp19_Excel_Cho7_Cap_Real_Estate Project Description: You are the office manager for a real estate company in northern Utah County. You tracked real estate listings,...

Q:

Grader - Instructions Excel 2019 Project Exp19_Excel_Ch07_Cap_Real_Estate Project Description: You are the office manager for a real estate company northern Utah County. You tracked real estate...

Q:

Project Description: You are the office manager for a real estate company in northern Utah County. You tracked real estate listings, including city, agent, listing price, sold price, etc. Agents can...

Q:

A business using the retail method of inventory costing determines that merchandise inventory at retail is $780,000. If the ratio of cost to retail price is 65%, what is the amount of inventory to be...

Q:

If not examined carefully, the graphical description of U.S. peanut production shown below can be misleading. a. Explain why the graph may mislead some readers. b. Construct an undistorted graph of...

Q:

The process of making investments toward fixed assets, both tangible and intangible, is known as Group of answer choices capital budgeting capital spending capital net spending none of these

Q:

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Q:

8. There is interest in measuring change (in knowledge, behavior, skill, etc.) from pretraining levels or in comparing two or more different programs.

Q:

6. The cost of the training creates a need to show that it works.

Q:

3. To evaluate the proportion of money spent on training development, administration, and evaluation as well as to compare monies spent on training for different groups of employees (exempt versus...