Skip to Content
Special Edition Using® Microsoft® Office 2003
book

Special Edition Using® Microsoft® Office 2003

by Ed Bott, Woody Leonhard
September 2003
Beginner to intermediate content levelBeginner to intermediate
1368 pages
56h 14m
English
Que
Content preview from Special Edition Using® Microsoft® Office 2003
740
Chapter 26 Using Formulas and Functions
5. Follow the wizard’s prompts to position lookup
formulas and related cells on the worksheet.
The first value the Lookup Wizard produces is
the label over the lookup column; it goes in
D1. The second value is the one you’ll change
later to lookup values; in this case, it goes in
cell A2. The third value contains the lookup
formula and goes in D2.
6. Repeat steps 2–5 to add the formula that looks
up information for other columns. For exam-
ple, to look up information in the Price column,
create a lookup formula and add it to cell C2.
26
Figure 26.13
Using Database Functions
Excel includes a dozen functions you can ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Special Edition Using Microsoft® Office XP

Special Edition Using Microsoft® Office XP

Ed Bott, Woody Leonhard
Special Edition Using Microsoft® PowerPoint® 2002

Special Edition Using Microsoft® PowerPoint® 2002

Patrice-Anne Rutledge, Tom Mucciolo

Publisher Resources

ISBN: 0789729555Purchase Link