Cell with VLOOKUP needs to add two cells

[MattVarnell]

I have a cell with the VLOOKUP function. I know that VLOOKUP searches down Column A until it finds what you told it to find, then returns the value of column you specify. The problem I am having is I will have the "item searched" listed more than one time and will need the sums of that item totaled.

My formula looks like this: =VLOOKUP(A63,March!$A$9:$G$42,7,FALSE)

For example, lets say that "Apples" are in A63. On the 4th of March I sell 4 apples, and on the 18th of March I sell 5 apples. I need the total in the formulated cell to read "9".

Thanks for your help!!!