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.