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