VLOOKUP used with Access DB inside of Excel Sheet

[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

 

[Dave Peterson]

Your formula doesn't look right.

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

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