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: http://www.excelforum.com/member.php...o&userid=19613
View this thread: http://www.excelforum.com/showthread...hreadid=493013