VLOOKUP used with Access DB inside of Excel Sheet
 

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

VLOOKUP used with Access DB inside of Excel Sheet
 

Your formula doesn't look right.

You may want to read more about =vlookup().

Debra Dalgleish has notes:
http://www.contextures.com/xlFunctions02.html

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