I've come across this problem too. There may be a better solution, but
mine was to concatenate the two values into one cell and then use
VLOOKUP to compare. So the formula would look like this:

=AccountID&ServiceRef

That creates a unique identifier across both dimensions. Seems to work
just fine.

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!