Help with finding missing character in formula

[cwby44]

Can you guys tell me where I am going wrong here? Been looking at it too long I think.

=IF(C39<>'COR Log'!B5,IFERROR(INDEX('COR Log'!B$6:B$100,MATCH("Approved",'COR Log'!D$6:D$100,0)),""),(IFERROR(INDEX('COR Log'!B$6:B$100,MATCH("APPROVED",'COR Log'!D$6:D$100,0))

Thank you

[Ace_XL]

Try

=IF(C39<>'COR Log'!B5,IFERROR(INDEX('COR Log'!B$6:B$100,MATCH("Approved",'COR Log'!D$6:D$100,0)),""),IFERROR(INDEX('COR Log'!B$6:B$100,MATCH("APPROVED",'COR Log'!D$6:D$100,0)),""))

[cwby44]

That worked great ACE - can you look at this one really quick? I think if we can get it to work I can finally be done with this thing that I have been working on for 3 days

=IF(AND(Bond="NO",Hardware="YES"),"HARDWARE",IF(Bond="YES","MISC GLAZING"),IFERROR(INDEX('COR Log'!B$6:B$100,MATCH("Approved",'COR Log'!D$6:D$100,0)),"")

[cwby44]

That worked great ACE - can you look at this one really quick? I think if we can get it to work I can finally be done with this thing that I have been working on for 3 days

=IF(AND(Bond="NO",Hardware="YES"),"HARDWARE",IF(Bond="YES","MISC GLAZING"),IFERROR(INDEX('COR Log'!B$6:B$100,MATCH("Approved",'COR Log'!D$6:D$100,0)),"")

[Ace_XL]

Try

=IF(AND(Bond="NO",Hardware="YES"),"HARDWARE",IF(Bond="YES","MISC GLAZING",IFERROR(INDEX('COR Log'!B$6:B$100,MATCH("Approved",'COR Log'!D$6:D$100,0)),"")))