Pass Array into Named Range and use in Vlookup

[ififthelement]

Hi,

I have an external sheet (FILE-2) where i have Tabular Data for a Test cycle. There is a Stats file (FILE-1) in which I read from the External Sheet and pass a Sheet Range (2-D Array) into Named Range (CYCLE_DATA in FILE-2).

All the above does well.

After this, in FILE-2 when i try to use Vlookup(lookupText, CYCLE_DATA, 2, False), I get #N/A.

is there a way to resolve this ?

 

[oldbrewer]

so export the data to be charted to a new sheet ?