Hi,

I am having some trouble with a vlookup function.

I have a sheet in my workbook which links to another workbook via the Microsoft Query from other sources application, the Query Table is named "Store_Info"

I have the following vlookup function which i have used the Structured References to the Query Table "Store_Info" as the Col_Ind_Num but it doesn't like it all and results in a #REF and cant understand why?

=VLOOKUP(C4,Store_Info[#All],Store_Info[[#Data],[Region]],FALSE)
I really want to get away from using a fixed number reference for the Col_Ind_Num as this is a dynamic reference and likely to change.

Any help much appreciated

Simon