second question - vlookup table_array reference listed

[James Dean]

Thank you for the update. I have one last question in
regards to the original question listed below. When I
reference a table in b6 that is in another file, the
formula will not return a number unless the other file is
open. Any idea how to correct this.
Thank you -- James Dean.

If anyone can help with this vlookup question I would
appreciate your input. I am trying to place in the
vlookup function
(VLOOKUP(lookup_value,table_array,col_index_num,FALSE), a
cell reference in each of the parameters (i.e. vlookup
(b5,b6,b7,false)) where the lookup_value is in b5, the
table_array name is in b6, and the col_index is in b7. I
can only get it to work with using cell references for
the parameters b5 & b7. I have to put the actual
parameter for b6 (table_array) in the formula itself.
Any ideas how I can get it to take the table array from
the referenced cell?

Thank you -- James Dean
..

 

[Don Guillett]

where c2 is your range in text format 'b2:z100
=VLOOKUP(C1,INDIRECT(C2),C3)
You could even have a drop down list of the different ranges if you do this
a LOT.