Using a Index and Match with sum bold VBA function

[askromi]

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!

[ChemistB]

Based on what you stated "If a value can be found within a certain range, then SUMBOLD the values within another range"
=IF(ISERROR(MATCH(A42,MIDs!A4:A16531,0), 0, sumbold(MIDs!$L$4:$L$6235)+sumifbold(MIDs!$N$4:$N$6235))

That will SUMBOLD the sum of the two ranges if there is a match of A42 in MIDs!A4:A16531. Otherwise it returns 0. Reverse the 0 and the SUMBOLDs if you want it the other way around. I'm assuming SUMBOLD is a FUNCTION not a SUB.

[askromi]

Thank you very much for your assistance. What I am really trying to do is to sum ONLY the bold items in a range if a value in another is matched. For example if (a4=MIDs!A4:A65000, then sum the bold items for that particular name or number. Any help you can provide further would be highly appreciated!