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:C54. Hide column B that contains the codes.

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:

Sembawang Electronics Ltd (SEL) is a manufacturer of component parts used in the biotechnology industry. The company has been on a growth trajectory with the governments emphasis on the...

Q:

To ensure successful delivery of any engineering projects, all phases of project must be planned accordingly with high considerations of three main issues safety, environment and ethics. Based on the...

Q:

according to fasb what justification is there for reporting unrealized gain or loss as part of net income?

Q:

Presented below are condensed financial statements adapted from those of two actual companies competing as the primary players in a speciality area of the food manufacturing and distribution...

Q:

4. Describe how learners receive, process, store, retrieve, and act upon information.

Q:

7. Explain the four components of program design: design document template, course or lesson plan, and course or lesson plan overview.

Q:

3. Incorporate adult learning theory into the design of a training program.