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

--
Message posted from http://www.ExcelForum.com

Hi
if your qurater in the format Qx is in cell A1 try:
=VLOOKUP(Reference!$E6,INDIRECT("CompanyData" &
A1),Reference!$F6,FALSE)


--
Regards
Frank Kabel
Frankfurt, Germany


> Whats up everyone. Can I have a table array that is dynamic based on
> an 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
> have =VLOOKUP(Reference!$E6,CompanyDataQ4,Reference!$F6,FALSE)
>
> Please let me know if this is possible and how to best achieve this
> goal. I have some vb in the project so if I need to add more its no
> problem. Thank you all in advance.
>
>
> ---
> Message posted from http://www.ExcelForum.com/

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

--
Message posted from http://www.ExcelForum.com

Hi
no chance with INDIRECT. Also most other alternatives (as shown in this
link: http://tinyurl.com/2c62u) won't work. You may use Harlan Grove's
PULL function in this case (also described in this link)

--
Regards
Frank Kabel
Frankfurt, Germany


> 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.
>
>
> ---
> Message posted from http://www.ExcelForum.com/