Skip to Content
Business Solutions Charts and Graphs for Microsoft® Office Excel® 2007
book

Business Solutions Charts and Graphs for Microsoft® Office Excel® 2007

by Bill Jelen
April 2007
Beginner to intermediate content levelBeginner to intermediate
480 pages
17h 6m
English
Que
Content preview from Business Solutions Charts and Graphs for Microsoft® Office Excel® 2007
249
Creating Dynamic Charts
This seems completely useless, doesn’t it? Has your manager ever called you to ask, “By the
way, can you tell me in what relative row number within a range that customer is located?”
This is a bit of trivia that rarely comes up in conversation. However, bear with me because
the
MATCH function can be useful when combined with the INDEX function, which is dis-
cussed in the next section.
The
MATCH function requires arguments that are similar to the first, third, and fourth argu-
ments of the
VLOOKUP function:
Lookup value—This is the value that you are trying to find.
Lookup array—This is the first column of the table array ...
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

Microsoft® Office Excel® 2007 Inside Out

Microsoft® Office Excel® 2007 Inside Out

Mark Dodge, Craig Stinson
What Successful Project Managers Do

What Successful Project Managers Do

W. Scott Cameron, Jeffrey S. Russell, Edward J. Hoffman, Alexander Laufer
How to Become a Game-Changing Leader

How to Become a Game-Changing Leader

Douglas A. Ready, Alan Mulally

Publisher Resources

ISBN: 0789736101Purchase book