Tablearray is the cell reference for the data table

  • No School
  • AA 1
  • 7

This preview shows page 4 - 6 out of 7 pages.

table_array is the cell reference for the data table, usually shown as a range. The col_index_num argument is the column number in the data table (table_array) where the matching value should be found. The range_lookup argument is a logical value of TRUE or FALSE, where TRUE represents the value found in the first column should be a closest match, and FALSE represents the value found in the first column should be an exact match. From the Excel Simulation below. If in a blank cell =VLOOKUP(C6. Future Value of $1!B3:T27,2,FALSE)" was entered the formula would output the result of 1.10462 in this example. Excel processes the VLOOKUP function by using each argument to find the cross-section of the column and row reference in the data table. In the example, Excel looked at the first column of the table_array on the Future Value of $1 tab cells B3.127 and found the lookup_value of the Sheet1 cell C6 reference, or 10 periods in this example. That position in the first column is stored in Excel to know what row the final result will be found in. Remember that the first column used is the first column of the table_array and not the first column of the worksheet tab. Then the col_index_num is used by Excel to determine what column of the table_array the final result is
Image of page 4
Included, or in this case the second column. Excel then finds the cross-section of those two values using the row and column references and outputs the final result from the data table. The Chestnut Street Company plans to issue $825,000, 10- year bonds that pay 7 percent semiannually on March 31st and September 30th. Information relating to this bond is found below: Face Value: $ 825,000 Number of Years: 10 Stated Interest Rate: 7% Number of Payments per Year: Required: Calculate or provide the information requested using a formula or cell reference unless you are instructed to
Image of page 5
Image of page 6

You've reached the end of your free preview.

Want to read all 7 pages?

  • Fall '19
  • present value factor tables

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors