I have unscrambled your merged cells as well as I can.
I found the errors in the Yellow area and they were do mainly because the VLOOKUP values were not in order and that is necessary for the VLOOKUP using TRUE. I changed that to False (0).
After the unmerging of the cells, the ranges were no longer correct...if they were correct in the first place.
Maybe this will help you out.
Bookmarks