Is it possible to use the VLookup function to point to a range of cells
instead of just a specific cell?

I am trying to use the VLookup function to act as a mechanism to
compile a series of charts.
So I would like to know if one can use the VLookup functions in the
SOURCE DATA "Values" and "Category (X) axis labels" fields.


Thanks in advance,
M Kane