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

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
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Michael Kintner" wrote:

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

You have a response at your other post.

Michael Kintner wrote:

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

--

Dave Peterson