Vlookup Help! Adding mutiple values.

[mightybhwk]

Hi all,

Newbie to this forum. I have been searching for an answer but can not find one. Hoping someone here can help.

What I trying to do is to come up with a formula to look at a date and a fixed number and search another worksheet for all instances of a that date and number and return the added amount of what it finds.


Example:

Sheet 1:
F4: 12/09/2011

Sheet 3:

A1: =CONCATENATE($B1,$C1) B1: 12/09/2011 C1: 57738 H1: -4000
A2: =CONCATENATE($B2,$C2) B1: 12/09/2011 C2: 57738 H2: -7000
A3: =CONCATENATE($B3,$C3) B1: 12/09/2011 C3: 54976 H3: -2000


I used:
=IF(ISNA(VLOOKUP(CONCATENATE(F4,57738),Sheet3!1:65536,8,FALSE)),"",VLOOKUP(CONCATENATE(F4,57738),Sheet3!1:65536,8,FALSE))

This formula will only pull in the first value. I need to pull in both -4000 and -7000 and add them together. -11000

Any ideas if this can work?

Thanks for any help

Randy

[Haseeb Avarakkan]

Use SUMIF instead of VLOOKUP,

=SUMIF(Sheet3!A:A,F4&"57738",Sheet3!H:H)

[mightybhwk]

Thanks! I will try it tomorrow.

[mightybhwk]

Thanks so much. This worked like a charm!