Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Home Page

Bloglines

1906
CelebrateStadium
2006


OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal












Subscribe here
Add to 

My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Thursday, April 23, 2009 – Permalink –

Lookup, Down, and Sideways

A very useful Excel feature


Excel 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.

All 'Bout Computers has an article describing "Lookups".

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.

Aaron Blood's site offers download files explaining lookup. See numbers 36, 37, and 44.

One of the zipped Workbooks (number 35) Lookup.zip, is a study in lookup methodology.

Daily Dose of Excel:
VLookup on Two Comumns




See all Topics

Labels:


<Doug Klippert@ 3:01 AM

Comments: Post a Comment