Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run Excel VBA code inside Access | Excel Discussion (Misc queries) | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
How to import multiple sheet of excel into Access database to a diffrent tables?? | Excel Discussion (Misc queries) | |||
Linking workbook and range protected Excel sheet to Access | Excel Discussion (Misc queries) | |||
Excel and Access talking | Excel Discussion (Misc queries) |