Look Up Values with 7000+ data points

I pull a list of bonds daily and I have a formula that calculates a score. I then need to input those the scores into a database on another sheet that already has existing bonds names and scores. The daily data pull consists of new bonds and also existing bonds that are in my database. I am trying to have new bonds be added to the database with score and name while existing bonds just have the score copied into the correct row and column (by bond name and date).

I tried using a nested for loop where I take one bond name from the new list and compare it to each bond name on the old list but with 7000+ bond names daily, the VBA program takes too long.

Is there anyway to use an existing Excel function with VBA to make this process faster and more efficient?