Hi,

You can simply copy my function down.
The function will change into
=OFFSET($B$1,MATCH(D1,$A$2:$A$7,1),0)
=OFFSET($B$1,MATCH(D2,$A$2:$A$7,1),0)
=OFFSET($B$1,MATCH(D3,$A$2:$A$7,1),0)
=OFFSET($B$1,MATCH(D4,$A$2:$A$7,1),0)
and so on...

Makes this things clear?

Executor