I am quite new to VBA, but I was able to find the macro to sumbold cells in a given range, but I am trying to lookup a certain value in another range and if that value is found then sum bold cells within another range. I have tried several different combinations of using if(xxx=xxx(sumbold( , or vlookup, index and match and,using VLOOKUP() nested inside the ISERROR() function. if result is TRUE, run the macro , etc but I cannot get the formula to work.

For example:

=ISERROR(VLOOKUP(A42,MIDs!A4:A16531,sumbold(MIDs!$L$4:$L$6235)+sumifbold(MIDs!$N$4:$N$6235),0))

I am hoping that someone with more experience might be able to help. If needed I will post the spreadsheet as well.
Thanks to anyone that can help!