Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using VLOOKUP to look up info from Access
Is there any way I can use the VLOOKUP function in Excel to pull in
information from Access and make calculations off that info? It would be helpful if I could set up an Excel worksheet that, once a loan number is typed in, it would just go to that Access table and look up the loan's information. I already have a worksheet set up with all the formatting and formulas the way I want them. I've been just exporting the Access table into an Excel worksheet periodically and that also works. My problem is that I think this Access table will soon be too big to export into Excel. I know I can set up a report similar to the way the Excel worksheet is set up, but I want the info to be stored in Excel and whenver I try to export the report into Excel, it loses all its formatting and just looks like a query. Can anyone help? Thanks, Michelle |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup, Bring up certain Info. only??? | Excel Discussion (Misc queries) | |||
Access or Excel for contact info lists & creating mailing labels | Excel Discussion (Misc queries) | |||
Excel/Access template to enter/sort utility bill info | Excel Discussion (Misc queries) | |||
Importing access database info into excel | Links and Linking in Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |