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.