Hi, R.V
In column B(1,5,2,1,4,12,3,3,5,7,5,1),some values are repeated(eg. 1,3,5).So
,here more than one corresponding values will be in column C. How to get
these values in column cells of E,by verifying values in D(viz ;
1,2,3,4,5,6,7,8,9,10,11,12).As column B contains three 1's,there will be
three corresponding values in cell C1.

I want a formula,if possible,for this.

I hope my requirement is clear now.
Thank you,
KSW

"R.VENKATARAMAN" wrote:

not understood clerly. is this waht you want;?

in E1 type repeat E1

=VLOOKUP(D1,$B$1:$C$12,2,FALSE)



K.S.Warrier wrote in message
...
If B1:B12 contains names/numbers not in any sort order( & some recurring)
&
C1:C12 the corresponding values/names .How to get value/values from C1:C12
by
verifying a value/name in D1 from B1:B12.
Eg:
B1 to B12 contains 1,5,2,1,4,12,3,3,5,7,5,1 and C1:C12 corresponding
value/text
Value in D1 yo be verified.
If B1:B12 are in any sort order & without repetition ,a formula
=lookup(D1,B1:B12,C1:C12) will give a value/name.