Question: I ' m trying to create a formula / function to populate the department number and department name using the values on the bottom (

I'm trying to create a formula/function to populate the department number and department name using the values on the bottom (similar to V-lookup) but I can't figure out how to look it up since 54,70,80 are to the rightest most of the account number. please help!
I ' m trying to create a formula / function to

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 Programming Questions!

Q:

I have been given the assignment to: Steganography is a technique of encoding a text message into a picture. Create a Steganographer class. Write a method for this class called "encode" that accepts...

Q:

This case will use an Excel Workbook as a Tutorial Tool (with learning content incorprated into each worksheet). Within the Workbook there will be multiple worksheets that the student will need to...

Q:

This case will use an Excel Workbook as a Tutorial Tool (with learning content incorprated into each worksheet). Within the Workbook there will be multiple worksheets that the student will need to...

Q:

Waren Sports Yearend Worksheet Introduction: Accountants use Excel to analyze transactions and accounts, prepare financial statements, calculate budgets, create invoices, and many more tasks....

Q:

Waren Sports Yearend Worksheet Introduction: Accountants use Excel to analyze transactions and accounts, prepare financial statements, calculate budgets, create invoices, and many more tasks....

Q:

1 Open the ClothingTech Pre-Project Analysis - Start workbook. 2 Cutt-Off Test: In steps 3 6 below, you are going to determine if there were any 2016 sales that were not shipped until 2017. While...

Q:

I need assistance with some SAP Classic Rockers Case Student Exercises (Setup, MM, PP, SD, FI/CO). let me know if interested. Chapter 1: Setup Exercises EXERCISE 1:SETUP PARAMETER ID This exercise...

Q:

Please I want the second and third part of the assignment. thanks First, Create a C# Console project named YourInitialsAsn1 (such as hpAsn1 for a student named Harry Potter). Use the Solution...

Q:

can someone help me with this please let me know if you need more info Required information [The following information applies to the questions displayed below.) This Applying Excel worksheet...

Q:

Introduction: Accountants use Excel to analyze transactions and accounts, prepare financial statements, calculate budgets, create invoices, and many more tasks. Mastering the basics of Excel is...

Q:

Calculate current ratio and quick ratio based on following data? Current assets: Cash and cash equivalents $ 76,000 Marketable securities 110,000 Trade and other receivables 230,000 Inventories...

Q:

Holly Hocks, Inc. had cash sales of $225,000 for 2012, its first year of operation. On April 2, the company purchased 200 units of inventory at $190 per unit. On September 1, an additional 150 units...

Q:

Which answer is correct: A, B, C or D? a 2569 rounded to 1 s.f. A 2 B 3 C 2000 D 3000 b 47.6821 rounded to 3 s.f. A 47.6 B 47.682 C 47.7 D 48.0 c 0.0882 rounded to 2 s.f. A 0.08 B 0.088 C 0.09 D 0.1...

Q:

Sarah would like to create a new custom management report template for her client. What are 2 options for accomplishing this