Defining a name

  • Thread starter Thread starter TwEaKFrEaK
  • Start date Start date
T

TwEaKFrEaK

Whats up everyone. Can I have a table array that is dynamic based on a
input sheet.

For example I have a lookup table that

=VLOOKUP(Reference!$E6,CompanyDataQ3,Reference!$F6,FALSE)

I would like CompanyDataQ3 to change based on the input sheet.

On the input sheet I have
Quarter


so if quarter on the input sheet is Q3 the lookup table will have
=VLOOKUP(Reference!$E6,CompanyDataQ3,Reference!$F6,FALSE)

if the quarter on the input sheet is Q4 than the lookup table will hav
=VLOOKUP(Reference!$E6,CompanyDataQ4,Reference!$F6,FALSE)

Please let me know if this is possible and how to best achieve thi
goal. I have some vb in the project so if I need to add more its n
problem. Thank you all in advance
 
Hi
if your qurater in the format Qx is in cell A1 try:
=VLOOKUP(Reference!$E6,INDIRECT("CompanyData" &
A1),Reference!$F6,FALSE)
 
THe only issue is that indirect requires the workbooks to be opened.
The results document has links to 25 workbooks. Any advice?


Thanks for helping me. I appreciate it a lot
 
Back
Top