Glad that you got it all sorted out ok!! :)

Max - out of interest could you tell me why there is a 1 after the
MATCH statement? I understand how the rest of it works - and will be
able to put that to good use in my own spreadsheets - just can't follow
that bit!

Cheers

Carl

Put in the formula bar for E2, then array-enter the formula
by pressing CTRL+SHIFT+ENTER (instead of just pressing ENTER):
=INDEX(X!$D$2:$D$10,MATCH(1,(X!$A$2:$A$10=B2)*(X!$ B$2:$B$10=C2)*(X!$C$2:$C$10=D2),0))*A2


--
mr_teacher
------------------------------------------------------------------------
mr_teacher's Profile: http://www.excelforum.com/member.php...o&userid=34352
View this thread: http://www.excelforum.com/showthread...hreadid=544797