{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Chapter_10_VLOOKUP_Tutorial

# Chapter_10_VLOOKUP_Tutorial - Chapter 10 Excel...

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

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.

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 2

Chapter_10_VLOOKUP_Tutorial - Chapter 10 Excel...

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

View Full Document
Ask a homework question - tutors are online