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.

See if this helps:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"Dave" wrote in message
...
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.