Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

State column (column C), enter a VLOOKUP() function that will find the state each customer lives in (based on the CustomerID (column B) in the

State column (column C), enter a VLOOKUP() function that will find the state each

customer lives in (based on the CustomerID (column B) in the RawData worksheet) using the

Customers worksheet, which contains each customer's data (including IDs, names and states).

In the Sector column (column E), enter Use a VLOOKUP() function to find the sector for each stock (based on the Ticker symbol (column D) in the RawData worksheet) using the Stocks worksheet, which contains each stock's data

TransactionID CustomerID State Ticker Sector Qty UnitPrice Total Dollar Value
TR093016275 CN0212689 CVS 4825 $84.25 $406,506.25
TR093011962 CN0357224 IP 975 $27.58 $26,890.50
TR093010648 CN0176022 LRCX 5400 $53.82 $290,628.00
TR093016432 CN0573414 GAS 12075 $26.95 $325,421.25
TR093003876 CN0150399 DOV 9100 $8.80 $80,080.00
TR093024190 CN0369936 CTSH 10750 $41.38 $444,835.00
TR093021236 CN0161873 THC 12250 $17.12 $209,720.00
TR093014330 CN0571492 BHI 4550 $113.91 $518,290.50
TR093025402 CN0260099 M 11825 $41.79 $494,166.75
TR093022880 CN0162005 AMGN 725 $9.20 $6,670.00
TR093017116 CN0102188 WEC 9000 $347.25 $3,125,250.00
TR093009306 CN0402962 AXP 3050 $25.08 $76,494.00
TR093004193 CN0685815 PCL 7100 $37.05 $263,055.00
TR093012693 CN0082231 GS 5775 $89.96 $519,519.00
TR093024338 CN0131189 LLL 11325 $95.22 $1,078,366.50
TR093014340 CN0599781 PPL 11750 $156.10 $1,834,175.00

CustomerID Customer Name Customer State
CN0428377 Peter Adkins Indiana
CN0402962 Ian Romero Illinois
CN0274973 Blakely Bender Maryland
CN0695674 Maverick Christensen California
CN0038382 Julia Schmidt Connecticut
CN0071909 Saul Coffey New Mexico
CN0668380 Jordyn Garrett New York
CN0055688 Ariana Diaz Florida
CN0735933 Tate House Minnesota
CN0483366 Carlos Obrien Arizona
CN0573845 Mario Holloway New York
CN0483327 Chelsea Carey Alabama
CN0527778 Dexter Galvan North Carolina
CN0743766 Connor Patterson Texas
CN0391784 Zuri Mercer Georgia

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

Cambridge IGCSE And O Level Accounting Coursebook

Authors: Catherine Coucom

2nd Edition

1316502775, 978-1316502778

More Books

Students also viewed these Accounting questions