I can't get anything from that image I am afraid, but just add the extra
condition like this

=INDEX(C1:C100,MATCH("criteria x",IF(((A1:A100="project
b")*(C1:C100="something")),B1:B100),0))

it is an array formula, so commit with Ctrl-Shift-Enter


--

HTH

RP
(remove nothere from the email address if mailing direct)


"MoonWeazel" wrote
in message ...

hi bob,

thanks for the help!

i need to be able to work in another criteria! there is more
information and a screen shot available in my second post!

thanks anyway!

moonweazel


--
MoonWeazel
------------------------------------------------------------------------
MoonWeazel's Profile:
http://www.excelforum.com/member.php...fo&userid=2119
View this thread: http://www.excelforum.com/showthread...hreadid=479424