Complex Lookup?
 

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


--
aileen
------------------------------------------------------------------------
aileen's Profile: http://www.excelforum.com/member.php...o&userid=36583
View this thread: http://www.excelforum.com/showthread...hreadid=563252

Complex Lookup?
 

I suggest you look at the sumif function

--
duan

-----------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...fo&userid=1162
View this thread: http://www.excelforum.com/showthread.php?threadid=56325