Try this:

=INDEX(C2:C10,MATCH(A12&CHAR(1)&A13,A2:A10&CHAR(1) &B2:B10,0))
Confirm the formula by holding down Ctrl and Shift, then hit Enter.
(It's an Array formula.)

Hope it helped
Ola Sandström


Example:
http://www.dicks-blog.com/archives/c...eet-functions/


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=378312