Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation 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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation using VLookup
Best to start by looking in the help index for VLOOKUP
-- Don Guillett Microsoft MVP Excel SalesAid Software "casdaq" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation using VLookup
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) -- Regards, Fred "casdaq" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date calculation and possible vlookup | Excel Worksheet Functions | |||
sum/division calculation involving vlookup with array? | Excel Worksheet Functions | |||
vlookup and calculation questions | Excel Worksheet Functions | |||
Vlookup Calculation Issue | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions |