Chapter_10_VLOOKUP_Tutorial - Chapter 10: Excel Tutorial...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 10: Excel Tutorial (Using the V-Lookup Table to Perform Sensitivity Analysis) After completing the tutorial, you will be able to use the V-Lookup function in Excel. Please refer to the information provided in Self-Study Problem No. 2. VLOOKUP Function – the following steps can be used to setup a VLOOKUP function . The VLOOKUP function searches for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify in a data table. This function can be useful in performing a sensitivity analysis. We will perform a sensitivity analysis on the sales price of $80 per unit that is included in the budgeted income statement. We will assume through this analysis that everything else remains constant. 1. Open the worksheet labeled “Template.” 2. You will now create the VLOOKUP function within cell I4, that is, the cell where you originally put the total sales of $480,000 in the budgeted income statement. 3.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/10/2012 for the course ACCOUNTING 5450 taught by Professor Brown during the Spring '12 term at Colorado Technical University.

Page1 / 2

Chapter_10_VLOOKUP_Tutorial - Chapter 10: Excel Tutorial...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online