Question: how do i vlookup multiple values?
Answer: Click on the VLOOKUP-Arrays worksheet tab in the VLOOKUP advanced sample file. ... 
Type the SUM-VLOOKUP formula in cell H3: ... 
Click Ctrl+Shift+Enter on your keyboard to add the curly brackets: