 |
 | 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 / September 2007Calculation using VLookup
I'm not too familiar with VLookup and I'm trying to find results in one workbook and divide against a result in another workbook. Does anyone know what the formula would look like for that. Here is a scenario below. Workbook 1 - Invoice Charges by location (Texas) Workbook 2 - Calls Handled by location (Texas) Workbook 3 - Texas - dividing Invoice Charges with Calls Handled Best to start by looking in the help index for VLOOKUP  SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > I'm not too familiar with VLookup and I'm trying to find results in one > workbook and divide against a result in another workbook. Does anyone know [quoted text clipped - 4 lines] > > Workbook 3 - Texas - dividing Invoice Charges with Calls Handled It would be helpful to know how your data is organized. However, maybe this will help steer you in the right direction. In workbook3, try something like: =vlookup(a1,'[Workbook1.xls]Sheet1!$A:$L,4,false)/vlookup(a1,'[Workbook2.xls]Sheet1!$A:$L,4,false) SignatureRegards, Fred > I'm not too familiar with VLookup and I'm trying to find results in one > workbook and divide against a result in another workbook. Does anyone know [quoted text clipped - 4 lines] > > Workbook 3 - Texas - dividing Invoice Charges with Calls Handled |
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
|
©2008 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.