software

I am trying to extract data from a list which is set up as follows:A2 Microsoft B2 31/12/2004 C2 10
A3 Microsoft B3 31/01/2005 C3 11
A4 Microsoft B4 28/02/2005 C4 12
A5 IBM B5 31/12/2004 C5 66
A6 IBM B6 31/01/2005 C6 69
A7 IBM B7 28/02/2005 C7 72
Etc

In one formula I would like to be able to extract the value from column
C that meets a crierion in both columns A and B - for example, IBM and
31/01/2005

I'd really appreciate it if someone can show me a formula that will do
this!

Many thanks!--
andrewc
------------------------------------------------------------------------
andrewc's Profile: www.excelforum.com/member.php...oamp;userid=19613
View this thread: www.excelforum.com/showthread...hreadid=493013Depending on what you want to do with the result...........one way is to
insert a new column A and concatenate the old A2 and B2 into the new A2, and
copy down, then use a VLOOKUP formula to find that value and step over to the
column you want....like
=VLOOKUP(Microsoftamp;31/01/2005,A2100,4,FALSE)
Vaya con Dios,
Chuck, CABGx3
quot;andrewcquot; wrote:

gt;
gt; I am trying to extract data from a list which is set up as follows:
gt;
gt;
gt; A2 Microsoft B2 31/12/2004 C2 10
gt; A3 Microsoft B3 31/01/2005 C3 11
gt; A4 Microsoft B4 28/02/2005 C4 12
gt; A5 IBM B5 31/12/2004 C5 66
gt; A6 IBM B6 31/01/2005 C6 69
gt; A7 IBM B7 28/02/2005 C7 72
gt; Etc
gt;
gt; In one formula I would like to be able to extract the value from column
gt; C that meets a crierion in both columns A and B - for example, IBM and
gt; 31/01/2005
gt;
gt; I'd really appreciate it if someone can show me a formula that will do
gt; this!
gt;
gt; Many thanks!
gt;
gt;
gt; --
gt; andrewc
gt; ------------------------------------------------------------------------
gt; andrewc's Profile: www.excelforum.com/member.php...oamp;userid=19613
gt; View this thread: www.excelforum.com/showthread...hreadid=493013
gt;
gt;


See if something like this works for you:

=SUMPRODUCT(--(A1:A6=quot;Microsoftquot;)*(B1:B6=quot;31/12/2004quot;),C1:C6)

Does that help?

Regards,
Ron--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: www.excelforum.com/member.php...oamp;userid=21419
View this thread: www.excelforum.com/showthread...hreadid=493013
Thank you both for your help!--
andrewc
------------------------------------------------------------------------
andrewc's Profile: www.excelforum.com/member.php...oamp;userid=19613
View this thread: www.excelforum.com/showthread...hreadid=493013