In Sheet1,

Should D1 actually contain the text "Tier" as well,
viz. in D1: Tier 3
(instead of just the number 3)

then use this version in D4:
=IF(COUNTA(D1:D2)<2,"",INDEX(Sheet2!$A$1:$D$7,MAT CH(SUBSTITUTE(D1,"Tier","")+0,Sheet2!$A$1:$A$7,0), MATCH(D2,Sheet2!$A$1:$D$1,0)))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---