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

Problem: I'm trying to combine the values of selected cells from multiple worksheets in the same workbook, but the formula is returning 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 EQUAL2 LM PRINBAL
LOAN_PARTICIPANT_PRINCIPAL LOAN_EV_VIEW NOT EQUAL2 NOT EQUAL2 LM PRINBAL
LOAN_PARTICIPANT_PRINCIPAL LOANMAST LM NOT EQUAL2 NOT EQUAL2 LM PRINBAL


LOAN_PARTICIPANT_PRINCIPAL BILL_PAYING_CURTAILMENT_DETAIL =IF(VLOOKUP(B7742,'@Table Alias'!A$1:B$298,2,FALSE)="","",VLOOKUP(B7742,'@Ta ble Alias'!A$1:B$298,2,FALSE)) =IF(ISERROR(A7742=INDEX(DMD_BASEL,MATCH(A7742,DMD_ BASEL!$A$2:$A$400,0),3)),"not match 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,'@Table Alias'!A$1:B$298,2,FALSE)="","",VLOOKUP(B7743,'@Ta ble Alias'!A$1:B$298,2,FALSE)) =IF(ISERROR(B7743=INDEX(DMD_BASEL,MATCH(A7743,DMD_ BASEL!$A$2:$A$400,0),2)),"NOT EQUAL1",IF(C7743=INDEX(DMD_BASEL,MATCH(A7743,DMD_B ASEL!$A$2:$A$400,0),2),"EQUAL1","NOT EQUAL2")) =IF(C7744=INDEX(DMD_BASEL,MATCH(A7744,DMD_BASEL!$A $2:$A$400,0),2),"EQUAL1","NOT EQUAL2 "&INDEX(DMD_BASEL,MATCH(A7744,DMD_BASEL!$A$2:$A$40 0,0),2)) =INDEX(DMD_BASEL,MATCH(A7743,DMD_BASEL!$A$2:$A$400 ,0),3)
LOAN_PARTICIPANT_PRINCIPAL LOAN_EV_VIEW =IF(VLOOKUP(B7744,'@Table Alias'!A$1:B$298,2,FALSE)="","",VLOOKUP(B7744,'@Ta ble Alias'!A$1:B$298,2,FALSE)) =IF(ISERROR(B7744=INDEX(DMD_BASEL,MATCH(A7744,DMD_ BASEL!$A$2:$A$400,0),2)),"NOT EQUAL1",IF(C7744=INDEX(DMD_BASEL,MATCH(A7744,DMD_B ASEL!$A$2:$A$400,0),2),"EQUAL1","NOT EQUAL2")) =IF(C7744=INDEX(DMD_BASEL,MATCH(A7744,DMD_BASEL!$A $2:$A$400,0),2),"EQUAL1","NOT EQUAL2 "&INDEX(DMD_BASEL,MATCH(A7744,DMD_BASEL!$A$2:$A$40 0,0),2)) =INDEX(DMD_BASEL,MATCH(A7744,DMD_BASEL!$A$2:$A$400 ,0),3)
LOAN_PARTICIPANT_PRINCIPAL LOANMAST =IF(VLOOKUP(B7745,'@Table Alias'!A$1:B$298,2,FALSE)="","",VLOOKUP(B7745,'@Ta ble Alias'!A$1:B$298,2,FALSE)) =IF(ISERROR(B7745=INDEX(DMD_BASEL,MATCH(A7745,DMD_ BASEL!$A$2:$A$400,0),2)),"NOT EQUAL1",IF(C7745=INDEX(DMD_BASEL,MATCH(A7745,DMD_B ASEL!$A$2:$A$400,0),2),"EQUAL1","NOT EQUAL2")) =IF(C7745=INDEX(DMD_BASEL,MATCH(A7745,DMD_BASEL!$A $2:$A$400,0),2),"EQUAL1","NOT EQUAL2 "&INDEX(DMD_BASEL,MATCH(A7745,DMD_BASEL!$A$2:$A$40 0,0),2)) =INDEX(DMD_BASEL,MATCH(A7745,DMD_BASEL!$A$2:$A$400 ,0),3)