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!!!

[Ron Coderre]

Try something like this:

Please Login or Register  to view this content.

Is that something you can work with?

[MattVarnell]

That doesn't work, it returns a value of "0". I am thinking I will have to have a VLOOKUP, because I have many different things to search.

[Ron Coderre]

You can make it easier for us if you post:
• A sample of your data
• Any formulas you've tried...even if they don't work
• Expected results that a correct formula would return, based on the sample data.

[MattVarnell]

Ron, here is a sample of what I need. On the first tab in column G is where I will input my data. On the "Totals" tab, is where I have my VLOOKUP formula to find "Apples". However, I need it to total the number of apples from the first tab.

Thanks for all your help!!

[ConneXionLost]

Hi MattVarnell,

With a quick change of the links to accommodate your sheet name, Ron's formula worked perfectly:

Please Login or Register  to view this content.

Cheers,

[MattVarnell]

You guys are awesome!! Thanks for your help!!!