Index/Match Formula Translate to VBA

Hello,

I am trying to figure out how to set up an IF statement and and Index/Match formula in VBA. I've tried and failed. Could someone help me figure out to set this up in VBA?

ESTDATA is a tab in my workbook, all other cell references are within the same worksheet.

Thanks so much!

=IFERROR(IF(MATCH(G8,C8,0),-SUMIF(ESTDATA!J:J,$A8,ESTDATA!$AB:$AB)*-E8),0)

=(INDEX(ESTDATA!$P:$P,MATCH($A15,IF(ESTDATA!$P:$P<>"",IF(ESTDATA!$P:$P<>"No Vendor",IF(ESTDATA!$P:$P<>"BUDGT",IF(ESTDATA!$P:$P<>"00000",ESTDATA!$J:$J),IF(ESTDATA!$P:$P<>"GENER",,0)))))))