Structured references in vlookup functions

[Simon.Ward]

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?

Please Login or Register  to view this content.

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

[Ganesh7299]

Hi, If you are looking for "Region" column as your Col_Ind_Num then you can try below solution

Please Login or Register  to view this content.

[Simon.Ward]

Ah its ok i have a solution, i was missing the "COLUMN"

Please Login or Register  to view this content.

Thanks anyway