In VLOOKUP how to pick Table_array value from a cell

[Guest]

I've to do Lookup for a range of values. These values are stored in different
files, which are stored in a cell for that row. So, I need VLOOKUP to pick
the value of the Table_Array from the cell instead of it being fixed.

Thanks

 

[Franz Verga]

Nel post *Amar Prasad* ha scritto:

I've to do Lookup for a range of values. These values are stored in
different files, which are stored in a cell for that row. So, I need
VLOOKUP to pick the value of the Table_Array from the cell instead of
it being fixed.

Thanks

You can use the INDIRECT function insiede the VLOOKUP function. If you could
post some example, maybe we can hepl better...


--
(I'm not sure of names of menues, option and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy