excel formula is returning incorrect values

[JaciM]

I've spent quite a few hours on this one and cannot figure it out. An
help will be appreciated.

Problem: I'm trying to combine the values of selected cells fro
multiple worksheets in the same workbook, but the formula is returnin
the same value even though the values (I've displayed) are different.

Please let me know your thoughts or suggestions. Thanks!

Following is a snapshot of the results along with the formula:

LOAN_PARTICIPANT_PRINCIPAL BILL_PAYING_CURTAILMENT_DETAIL FALSE3 LM PRINBAL
LOAN_PARTICIPANT_PRINCIPAL BOA_DMF_EV DMF NOT EQUAL2 NOT EQUAL
LM PRINBAL
LOAN_PARTICIPANT_PRINCIPAL LOAN_EV_VIEW NOT EQUAL2 NOT EQUAL
LM PRINBAL
LOAN_PARTICIPANT_PRINCIPAL LOANMAST LM NOT EQUAL2 NOT EQUAL
LM PRINBAL


LOAN_PARTICIPANT_PRINCIPAL BILL_PAYING_CURTAILMENT_DETAIL =IF(VLOOKUP(B7742,'@Tabl
Alias'!A$1:B$298,2,FALSE)="","",VLOOKUP(B7742,'@Tabl
Alias'!A$1:B$298,2,FALSE)) =IF(ISERROR(A7742=INDEX(DMD_BASEL,MATCH(A7742,DMD_BASEL!$A$2:$A$400,0),3)),"no
matc
1",IF(C7742=INDEX(DMD_BASEL,MATCH(A7742,DMD_BASEL!$A$2:$A$400,0),3),INDEX(DMD_BASEL,MATCH(A7742,DMD_BASEL!$A$2:$A$400,0),3),"FALSE3")) =INDEX(DMD_BASEL,MATCH(A7742,DMD_BASEL!$A$2:$A$400,0),2) =INDEX(DMD_BASEL,MATCH(A7742,DMD_BASEL!$A$2:$A$400,0),3)
LOAN_PARTICIPANT_PRINCIPAL BOA_DMF_EV =IF(VLOOKUP(B7743,'@Tabl
Alias'!A$1:B$298,2,FALSE)="","",VLOOKUP(B7743,'@Tabl
Alias'!A$1:B$298,2,FALSE)) =IF(ISERROR(B7743=INDEX(DMD_BASEL,MATCH(A7743,DMD_BASEL!$A$2:$A$400,0),2)),"NO
EQUAL1",IF(C7743=INDEX(DMD_BASEL,MATCH(A7743,DMD_BASEL!$A$2:$A$400,0),2),"EQUAL1","NO
EQUAL2")) =IF(C7744=INDEX(DMD_BASEL,MATCH(A7744,DMD_BASEL!$A$2:$A$400,0),2),"EQUAL1","NO
EQUAL
"&INDEX(DMD_BASEL,MATCH(A7744,DMD_BASEL!$A$2:$A$400,0),2)) =INDEX(DMD_BASEL,MATCH(A7743,DMD_BASEL!$A$2:$A$400,0),3)
LOAN_PARTICIPANT_PRINCIPAL LOAN_EV_VIEW =IF(VLOOKUP(B7744,'@Tabl
Alias'!A$1:B$298,2,FALSE)="","",VLOOKUP(B7744,'@Tabl
Alias'!A$1:B$298,2,FALSE)) =IF(ISERROR(B7744=INDEX(DMD_BASEL,MATCH(A7744,DMD_BASEL!$A$2:$A$400,0),2)),"NO
EQUAL1",IF(C7744=INDEX(DMD_BASEL,MATCH(A7744,DMD_BASEL!$A$2:$A$400,0),2),"EQUAL1","NO
EQUAL2")) =IF(C7744=INDEX(DMD_BASEL,MATCH(A7744,DMD_BASEL!$A$2:$A$400,0),2),"EQUAL1","NO
EQUAL
"&INDEX(DMD_BASEL,MATCH(A7744,DMD_BASEL!$A$2:$A$400,0),2)) =INDEX(DMD_BASEL,MATCH(A7744,DMD_BASEL!$A$2:$A$400,0),3)
LOAN_PARTICIPANT_PRINCIPAL LOANMAST =IF(VLOOKUP(B7745,'@Tabl
Alias'!A$1:B$298,2,FALSE)="","",VLOOKUP(B7745,'@Tabl
Alias'!A$1:B$298,2,FALSE)) =IF(ISERROR(B7745=INDEX(DMD_BASEL,MATCH(A7745,DMD_BASEL!$A$2:$A$400,0),2)),"NO
EQUAL1",IF(C7745=INDEX(DMD_BASEL,MATCH(A7745,DMD_BASEL!$A$2:$A$400,0),2),"EQUAL1","NO
EQUAL2")) =IF(C7745=INDEX(DMD_BASEL,MATCH(A7745,DMD_BASEL!$A$2:$A$400,0),2),"EQUAL1","NO
EQUAL
"&INDEX(DMD_BASEL,MATCH(A7745,DMD_BASEL!$A$2:$A$400,0),2)) =INDEX(DMD_BASEL,MATCH(A7745,DMD_BASEL!$A$2:$A$400,0),3