I'm sorry - I don't know how to adjust that to suit! I'm not all that good
with formulas.
In workbook1, I have acct id(a), service(b), sales account(c).
In workbook2, I have acct id(a), service(b), and i need to pull the sales
account in, but only if acct id & service in wkbk1 match acct id & service in
wkbk2.



"Teethless mama" wrote:

=SUMPRODUCT(--(A1:A100="account id"),--(B1:B100="service"),C1:C100)
Adjust to suit


"o1darcie1o" wrote:

I hope I can explain this ok:
My vendor reports an Account ID listed multiple times, once for each service
subscribed to. My billing is based on the two items: some services are
billed under one sales account, some on another.
I currently have my sheet set up where it is sorted by service and I vlookup
the account ID for each service seperately (using exact cell locations
instead of columns).
Is there a formula so that it looks at the account id, then the service, and
returns the sales account?
I hope that was clear - thanks in advance for your help!