Perspectives on microsoft excel 2010 xp xp 24 using

Info iconThis preview shows page 1. Sign up to view the full content.

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

Unformatted text preview: ting Nested IFs New Perspectives on Microsoft Excel 2010 XP XP 24 Using Lookup Tables and Functions Lookup functions XP XP • Allow you to use tables of data to “look up” values and insert them in another worksheet location Lookup tables – Store data and organize it into categories (compare values) – Can be constructed as either exact match or approximate match lookups – • New Perspectives on Microsoft Excel 2010 25 Using Lookup Tables and Functions (value you are trying to Lookup values XP XP • find) – Need to match one of the compare values – Can be used as part of a formula New Perspectives on Microsoft Excel 2010 26 Using the VLookup Function to Find an Exact Match • • • XP XP Searches a lookup table and, based on what you entered, retrieves the appropriate value from that table Searches vertically down the first column of the lookup table Syntax: New Perspectives on Microsoft Excel 2010 27 Using the VLookup Function to Find an Exact Match New Perspectives on Microsoft Excel 2010 XP XP 28 Using the VLOOKUP Function toXP XP Find an Approximate Match • • • Returns a value based on an approximate match lookup Searches the first column of the table until it locates the largest value that is less than the lookup value Then moves across the row in the table to retrieve the corresponding value New Perspectives on Microsoft Excel 2010 29 Using the VLOOKUP Function toXP XP Find an Approximate Match New Perspectives on Microsoft Excel 2010 30 Looking Up Values Using the HLOOKUP Function • • • XP XP Searches horizontally across top row of lookup table and retrieves the value in the column you specify Use when comparison values are located in the first row of the lookup table and you want to look down a specified number of rows to find the data to enter in another cell Syntax: New Perspectives on Microsoft Excel 2010 31 Looking Up Values Using the HLOOKUP Function • XP XP Major difference between HLOOKUP and VLOOKUP func...
View Full Document

This document was uploaded on 02/24/2014.

Ask a homework question - tutors are online