No, no, ditch the vlookup. Just use the SUMIF to get the totals for each
unique name. Thought that was the core issue?

You can use/apply autofilter on col A (insert a new header row first) to
easily retrieve the multiple line returns by name. Just choose the name from
the autofilter dropdown in A1.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"sross002" wrote:
Do I put that into the same cell that I have the VLOOKUP formula? How would
I squeeze it in with that formula?