Help me out

V

Vikram Dhemare

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I pull the col. index value as well as row index value 1
Please direct me to help with Microsoft Visio 2007 2
MACRO HELP, PASTE CELL TO COLUMN 0
Making Me Crazy ~ Please Help... 1
conditional statement help 4
Please help. This is way too tough for me. 2
Transfer data from Excel col. A to multiple columns in the same sh 0
New to SUMPRODUCT .. is there a better way? 1

Top