vba formula problem

[rjmdc]

Hi
Please see if you can easily fix
It is NOT choosing when column C says status “A” I think that’s missing form the formula but I don’t know how to add it
where its red its not working i am using the "A" incorrectly


Cells(target.Row, "Q").Formula2R1C1 = _
"=IF([@[Tabs ID]]="""","""",IFERROR(INDEX(Vendors_with_Addresses[Payee], MATCH(TEXT(INDEX('ClassesMemberships Names'!R1C3:R10000C3, MATCH(1, (""Y""='ClassesMemberships Names'!R1C4:R10000C4)*('ClassesMemberships Names'!R1C1:R10000C1=[@[Class/Membership Name]]),0), 0), 0),Vendors_with_Addresses[Vendor ID], 0), 0),IFERROR(INDEX('Vendors with Addresses'!C[-16], " & _
"MATCH(1,('Vendors with Addresses'!C[-4]=Value([@[Tabs ID]]))*('Vendors with Addresses'!C[-14]=" & Chr(34) & "A" & Chr(34) & "),0)), ""CHOOSE OVERRIDE PAYEE"")))" & _
""

 

[GlennUK]

After the formula is added to the sheet, outside of VBA, did you step through the formula using the Formula Auditing tool Evaluate Formula, to see if the test of column C being "A" works or not?