Book Home Page Bloglines 1906 CelebrateStadium 2006 OfficeZealot Scobleizer TechRepublic AskWoody SpyJournal Computers Software Microsoft Windows Excel FrontPage PowerPoint Outlook Word Host your Web site with PureHost! |
Friday, January 29, 2016 – Permalink – Lookup, Down, and SidewaysA very useful Excel featureExcel does not have "relational" tables like database applications such as Access. You, however, can make use of database functions including the ability to look up values in a table based on a value. You could, for instance look up a salesperson's records based on an employee ID. Using VLOOKUP, HLOOKUP, INDEX, and MATCH in Excel to interrogate data tables John Walkenbach has a book "Excel 2003 Formulas" with a 24-page chapter on Lookup functions and other database/list tricks. Chip Pearson talks about lookups on his site as well.. Daily Dose of Excel: VLookup on Two Comumns See all Topics excel Labels: Formulas, Functions, General, Reference, Tips, Tutorials <Doug Klippert@ 3:49 AM
Comments:
Post a Comment
|