I have got one Excel Table like,
A1 B1 C1
RC1 Ch. Nos. Details Model
RC2 28431600 Fr LH LUX
RC3 FR RH LUX
RC4 RR LH LUX
RC5 RR RH LUX
RC6 28431601 Fr LH STD
RC7 FR RH STD
RC8 RR LH STD
RC9 RR RH STD

& so on.
now I want to retrieve / pull the data of subsequent column by giving
criteria of Ch. nos. I know there are limitations by using lookup funtions,
Suppose I want to pull the data like in cell E2 that if Enter the Ch. No. in
D2, 2431601
then the answer in subsequent cell would be,

i.e
in Cell E2 - FR LH STD
in Cell E3 - FR RH STD
in Cell E4 - RR LH STD
in Cell E5 - RR RH STD
that means I row of column 2nd & 3rd
that means II row of column 2nd & 3rd
that means III row of column 2nd & 3rd
that means IV row of column 2nd & 3rd

Is their any functions for this
Will anybody help me out from this.
--
Thanks in advance
Vikram P. Dhemare