Using conditional linking (if that makes sense)

  • Thread starter Thread starter Dan S.
  • Start date Start date
D

Dan S.

I have a spreadsheet with three different worksheets. On
the first is a count of the number of credits by month,
broken down by company. The second is a count of the
number of payments by month, also broken down by company.
I would like to combine these on the third worksheet, so
that for each company, I could put in a formula to
reference the other worksheet and get the number of
credits and payments by that company. I imagine this can
be done; I just don't know how to do it.

Any help is greatly appreciated.

Thanks,

-Dan.
 
Dan S. said:
I have a spreadsheet with three different worksheets. On
the first is a count of the number of credits by month,
broken down by company. The second is a count of the
number of payments by month, also broken down by company.
I would like to combine these on the third worksheet, so
that for each company, I could put in a formula to
reference the other worksheet and get the number of
credits and payments by that company. I imagine this can
be done; I just don't know how to do it.

Any help is greatly appreciated.

Thanks,

-Dan.
Click to expand...

It really depends on how your worksheets are structured.

If the list of companies is the same on credits and payments sheets, then
cell (say) D17 on each will refer to the same company, so your formula on
the third sheet would just refer to Credits!D17 and Payments!D17.

If this is not so, then on the third sheet you will need to use the VLOOKUP
function to look up the company name on each of the other two and return
corresponding data. For example,
=VLOOKUP(A1,Credits!A1:C100,3,0)
will take the data in A1 (company name) and look it up in the first column
of Credits!A1:C100 (i.e. column A), returning the corresponding data from
the 3rd column of that range (i.e. column C), looking for an exact match
(the parameter 0).
Look in Help for details. If you have trouble, post back, quoting the
formula you have constructed and explaining the problem.
 
Back
Top