There are certain limitations with using LOOKUP.
LOOKUP function can only look up a value from left to right. This means that the column containing the value you look up should always be located to the left of the column containing the return value. Now if your spreadsheet isn't built this way, then arrange the columns in your spreadsheet in the order such that the column in which you lookup the values should always be to the left of the column conataining return values. i.e, in the given question the Expenses column should be to the left of the sale rep column in the spreadsheet.
since you have to lookup the expenses value keep the expenses column as first column in the spreadsheet.Since it is a vertical table use VLOOKUP Function
=VLOOKUP(Your lookup value,Your table array,the return value column number in table array,0)
After arranging the array, here I have created a cell with expense and other cell with name. The expenses value i have to lookup to be mentioned in the cell and the return value will i.e Name od sale rep will be displayed since i used vlookup function. Here the formula given is
=VLOOKUP(Expense cell reference, table array,the sale rep column is 3rd column in table so 3 is mentioned, since i need eaxct match we have to mention 0)
And the other way without arranging the columns instead of using LOOKUP function use the combination of INDEX and MATCH functions.
we'll use the MATCH function to find 200.22 in the range C2:C22. It's found in row 20. Then, INDEX uses that value as the lookup argument, and finds the Name of Sale rep for 200.22 in the 2nd column . The picture is attached below.
An auditor found an expense receipt for $200.22 without a name. Write a left table lookup...
Sales Rep Expenses ($) Crawford 221.39 Crawford 81.58 Crawford 233.43 Crawford 87.54 Crawford 108.43 Crawford 200.73 Crawford 212.59 Crawford 162.23 Crawford 192.52 Crawford 215.36 Crawford 150.78 Crawford 111.17 Crawford 187.45 Crawford 135.86 Jones 94.35 Jones 232.76 Jones 195.17 Jones 148.33 Jones 278.91 Jones 264.97 Jones 200.33 Jones 81.23 Jones 96.48 Jones 153.56 Jones 256.86 Jones 201.57 Jones 164.09 Jones 270.56 Smith 217.52 Smith 170.19 Smith 158.11 Smith 184.25 Smith 125.65 Smith 87.19 Smith 151.95 Smith 113.32 Smith 134.43 Rogers 172.51...
Could you please help me journalize these transactions. Thank you Name: Date: PAULA'S BOUTIQUE This Mini Practice Set aids in putting the pieces of recording transactions for a merchandising company together. In this project you are the bookkeeper and have the responsibility of journalizing sales, sales returns, purchases, purchase returns, cash receipts, and cash payments, as well as posting and recording to the appropriate ledger accounts, and preparing a trial balance on the first two columns of a ten-column worksheet....
Stuck on Income statement Interest Expense and Depreciation Expense Previous year Balance sheet Previous year Income Statement AutoSave Problem1_Student File_F20V2.xlsx - Read-Only - Excel OB 2 Data View Team Review Help Formulas File Home Insert Page Layout - General - 11 - A A 2 Wrap Text Calibri Xcut Copy 3 Format Painter a.A BIU $ - % Merge & Center IM Num! Font Alignment Clipboard D22 1 Sales for 2019 2 Cost of goods sold as percent of sales...
DROP TABLE IF EXISTS customers; DROP TABLE IF EXISTS orders; DROP TABLE IF EXISTS order_details; DROP TABLE IF EXISTS items; DROP TABLE IF EXISTS artists; DROP TABLE IF EXISTS employees; -- create tables CREATE TABLE customers ( customer_id INT , customer_first_name VARCHAR(20), customer_last_name VARCHAR(20) NOT NULL, customer_address VARCHAR(50) NOT NULL, customer_city VARCHAR(20) NOT NULL, customer_state CHAR(2) NOT NULL, customer_zip CHAR(5) NOT NULL, customer_phone CHAR(10) NOT NULL, customer_fax CHAR(10), CONSTRAINT customers_pk...
JPL, Inc. has provided its sales and expense data for the most recent period. The Controller has asked you prepare a spreadsheet that shows the related CVP Analysis computations. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, “=B5” was entered, the formula would output the result...
JPL, Inc. has provided its sales and expense data for the most recent period. The Controller has asked you prepare a spreadsheet that shows the related CVP Analysis computations. Use the information included in the Excel Simulation and the Excel functions described below to complete the task Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below,, if in a blank cell, "-B5" was entered, the formula would output the result...
JPL, Inc. has provided its sales and expense data for the most recent period. The Controller has asked you prepare a spreadsheet that shows the related CVP Analysis computations. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, "=B5" was entered, the formula would output the result...
consolidated statement of operations for Apple. 1.identfy the company's effective tax rate for 2014. 2. find out the company's net income in 2014. explain how it has changed from 2013. Millions, except Share data in Thousands, unless otherwise specified D E $156,508 87,846 68,662 C 2 Thousands, unless otherwise specified $182,795 $170,910 3 Net sales 112,258 106,606 4 Cost of sales 70,537 64,304 5 Gross margin 6 Operating expenses: 6,041 4,475 7 Research and development 11,993 10,830 8 Selling, general...
Could I get these journalized.. Thank you Especially the one's dated: March 10 (check no 111), March 14 (invoice no 52), March 18 (invoice no 51), March 23 (check no 114) We were unable to transcribe this imagePAULA'S BOUTIQUE POST-CLOSING TRIAL BALANCE February 28, 2012 Cash Petty Cash Accounts Receivable Merchandise Inventory Prepaid Rent Delivery truck Accumulated Depreciation, Truck Accounts Payable State Sales Tax Payable Paula Miller, Capital Totals 4,035.00 75.00 3,800.00 9,675.00 3,110.00 10,370.00 2,600.00 3,285.00 10,540.00 14,640.00 31,065.00...