I want Excel to look at column a, then at column b, and based on the
combination compared to sheet2, return the value from sheet2, col C.
As detailed as I can:
Sheet1 (<--this is the actual name of the sheet - easier for getting help!!)
A(Cust) B(Svc) C(Acct) D(Master) E(Ledger)
1006 DJNS
1006 ER
1214 DJNS
1345 PIR
Sheet2 - Exact same column mapping, but C, D, & E contain data based on the
combination of A & B. 1006 appears in both DJNS & ER, and they will have
different account numbers (column C) depending on which it is. The sheets do
not have the same number of lines, so I need excel to go through both columns
and get an exact match.
I really hope that makes sense!!

I tried: =IF(AND($A1=SHEET2!$A1,$B1=SHEET2!$B1),SHEET2!C1," ") and copied
down my list over 2000 lines, but only some of the information worked.

Thanks in advance!! Darcie