Sorry...couldn't open your attachment from the other newsgroup.

Here are the actual formulae base on your attachment:

=INDEX(Sheet2!$C$8:$N$21,MATCH($A6,Sheet2!$A$8:$A$ 21,0),MATCH(Sheet1!$A$2,Sheet2!$C$5:$N$5,0))
for A..copy down..and for B
=OFFSET(INDEX(Sheet2!$C$8:$N$21,MATCH($A6,Sheet2!$ A$8:$A$21,0),MATCH(Sheet1!$A$2,Sheet2!$C$5:$N$5,0) ),1,0)
copy down

HTH
JG


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