VLOOKUP Multiple re-occurring codes in the database

Hello

I am attempting to create a cost analysis for a pro-forma for my work using VLOOKUP function. I use VLOOKUP to bring up the number of units assigned to a certain code, however my tables often have the same code multiple times and I need to add the units assigned to these codes without changing the table. VLOOKUP only brings up the first unit assigned to the lookup code. Is there any way to use a combination of SUM and VLOOKUP in order to add all the units together. Please see the attachment.

In the attachmentm the Units column I have entered some units that I looked up myself in order to test my VLOOKUP function. The codes I am referencing are under the J column under Care HCPC. If you scroll down to row 47, code 38525 you will see that there should be 8 units showing up under column S under All Other for surgeries but only one shows up. There are eight instances of the code showing up in the table in the "Surgery All Other" tab. Is there any way to add these up without changing the table?