Hi, I think what you want is an INDEX, MATCH formula:

=INDEX(E2:G4,MATCH(B1,D2:D4,0),MATCH(A1,E1:G1,0))

where
E2:G4 is your range with all the combination
D2:D4 is your row header
E1:G1 is your column header
A1 is a value from your column header
B1 is a value from row header

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=495377