Prev: I need a formula to mark up a product by 200%
Next: vlookup multiple data
From: Dave on 4 Mar 2010 22:08
I have two different datasets. Each with a common identifier. I need a
formula that will reference the identifiers in both datasets and count the
number of sales a particular agent made. Example. look up this identifier
in the other dataset and then give me the value that is 2 columns over from
the identifier in the second dataset.
From: T. Valko on 4 Mar 2010 23:30
See if this helps:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"Dave" <Dave(a)discussions.microsoft.com> wrote in message
news:E7245B37-033F-400E-9CEE-9822BE7CB0F5(a)microsoft.com...
>I have two different datasets. Each with a common identifier. I need a
> formula that will reference the identifiers in both datasets and count the
> number of sales a particular agent made. Example. look up this
> identifier
> in the other dataset and then give me the value that is 2 columns over
> from
> the identifier in the second dataset.


 | 
Pages: 1
Prev: I need a formula to mark up a product by 200%
Next: vlookup multiple data