Solved

# 2 Questions Involving Lookups for An Array in a different workbook

Posted on 2014-10-10

Hello,

I am working with multiples trying to automate an end of a month progress. And a couple questions have arisen that I can't seem to solve.

This formula works to pull the appropriate value

=VLOOKUP(VLOOKUP($A:$A,'Key to 13 Month'!$A:$B,2,FALSE),'Q:\1 - Financial Reporting\2014\08 - 2014 Experiment\PL Prelims\[13 MO Adj EBITDA.xls]Hawaii'!$A$1:$N$65536,14,FALSE)

And this formula works.

{=SUM(VLOOKUP("Storage - Hard Copy",'Q:\1 - Financial Reporting\2014\08 - 2014 Experiment\PL Prelims\[13 MO Adj EBITDA.xls]Hawaii'!$A$1:$N$65536,{7,8,9,10,11,12,13,14},FALSE))}

1)However, I can't seem to turn that second formula into a Vlookup from a hard code. Is it possible or does it require hard coding?

2)Is there a way to turn the array into a cell reference? {7,8,9,10,11,12,13,14} I've tried with no success.