Complex Lookup?

[aileen]

Hi Guys

Does anyone know if it is possible to use vlookup to search for a value
in say column B but there may be up to 3 of the same values and return
the value in column D and if more than one value a sum of the values in
column D.


So say For example:
In column B, I have Q3-06, Q4-06 etc and in column C I have the
different months of the year and in column D I have a total figure for
each month.
Is it possible to lookup column B to find all Q3-06 values and return a
sum of values in column D?


If not possible anyone have any ideas how I could do this?
I am new at VB so any help would be much appreciated.
Thanks

[duane]

I suggest you look at the sumif function.