In VLOOKUP how to pick Table_array value from a cell
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
|