Calculation using VLookup

C

casdaq

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
 
F

Fred Smith

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)
 
Top