Vlookup formula to convert text to values

I have a SourceData that displays values as text and a subsequent table that pulls from it. How can I modify my Vlookup formula in Table1 so data is pulled as values and my Total row works correctly?

You can put a double-minus in front of your VLOOKUP function like this in C8:

=IFERROR(--VLOOKUP($B8,SourceData,2,FALSE),"")

then copy down. This will convert the text value to a numeric value. Do the same for D8.

Hope this helps.

Pete