 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / June 2006VLOOKUP using another table for comparison values
Can I use VLOOKUP to compare values in another table? What would that formula look like? I've been going through various 'help' areas and cannot find a sample of how that would look. Thank you. I think the answer is yes but need more details on your tables to give a definative answer with suggestions on how to do it. > Can I use VLOOKUP to compare values in another table? What would that > formula look like? I've been going through various 'help' areas and cannot > find a sample of how that would look. > > Thank you. It's a little complicated. I download data from another program and covert it to an Excel file. (Call it BUDGETDATA) In the far left column is a list of general ledger accounts. In other columns are listed budgeted amount, actual amount expended, amounts pending, etc. I need to pull the data from there into another Excel File (Call it REPORT). My Report has several worksheets in it (each pertaining to different budget areas) and I download budget data for each area, or worksheet. Does this help or do you need more info? Thank you :-) > I think the answer is yes but need more details on your tables to give a > definative answer with suggestions on how to do it. [quoted text clipped - 4 lines] > > > > Thank you. I think that vlookup will do what you want. set up the equation in your report file and use the cursor to select the range in the Budgetdata file to get data from. You may have to play with the vlookup format to get it to do exactly what you want, check the options listed in help. > It's a little complicated. I download data from another program and covert > it to an Excel file. (Call it BUDGETDATA) In the far left column is a list [quoted text clipped - 15 lines] > > > > > > Thank you. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.