Maybe you're after something like this:
http://www.freefilehosting.net/download/3id4e
Mally_1.xls

Inputs assumed within B1:K8
to denote selections from B9:K9
B19:K19 is the same as B9:K9

In B11: =IF(B1=B$19,ROWS($1:1),"")
B11 copied across/filled down to K18 to cover input range in B1:K8

Spare a moment to hit the "Yes" button below, won't you?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---