VLOOKUP PULLING TOTAL SUM FROM A MULTIPLE RAWS

Hello there.  Need help pls.   I want to know, how I can pull out the total SUM of multiple rows by VLOOKUP. With VLOOKUP, I look up for the value (Example Invoice number ADL01) in sheet 1 and pull...