Data Link and VLookup Problem

[Michael Kintner]

I think my problem is simple but not sure show to grab it.

I have created a new sheet called IMS-Data which is a linked sheet to a
Microsoft Access Table with data. In Sheet1 I am looking for the data via
the VLOOKUP. Because the data table length may change in size I wanted to
use the ranage name.

When I look at the IMS-DATA Sheet it shows a range name of
Query_from_IMS_ACCESS. However when I add that name in the VLOOKUP it
fails.

Formula used
=VLOOKUP(C4,Query_from_IMS_ACCESS,'IMS-Data'!G:G)

Any ideas on how to fix this?

Thank you in advance,
Mike

 

[Guest]

You need to specify the relevant column number. It looks like you want
column G. Assuming the range starts at column A, column G is equivalent to
7. So try: =VLOOKUP(C4,Query_from_IMS_ACCESS,7)

If the range does not start in column A, adjust the column index number
accordingly.


Dave

 

[Dave Peterson]

You have a response at your other post.

I think my problem is simple but not sure show to grab it.

I have created a new sheet called IMS-Data which is a linked sheet to a
Microsoft Access Table with data. In Sheet1 I am looking for the data via
the VLOOKUP. Because the data table length may change in size I wanted to
use the ranage name.

When I look at the IMS-DATA Sheet it shows a range name of
Query_from_IMS_ACCESS. However when I add that name in the VLOOKUP it
fails.

Formula used
=VLOOKUP(C4,Query_from_IMS_ACCESS,'IMS-Data'!G:G)

Any ideas on how to fix this?

Thank you in advance,
Mike