VLookup (possible to point to a range)

[kane.marc]

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

 

[Guest]

hi Kane,

if you have more than one condition is better to use a sumproduct instead of
vlookup,

as =sumproduct(--(range=x)*(range=y)*(range))

range=x first cond
range=y second cond
range = look area

hth
regards from Brazil
Marcelo

"(e-mail address removed)" escreveu: