Pls help

[yogesh7980]

I am stuck with the problem, pls help..
I have a list in column A
A1=12
A2=14
A3=15
A4=16
A5=1
A5=76
I have another list in column B
B1=24
B2=25
B3=28
B4=29
B5=3
B6=21

Now when I want to make condition where if C10=A1 then D10=B1, in this case can I add a C10 as a list containing values from A1 to A5, and now if I select A2 in C10 then D10 should become B2.

Pls help.

[mudraker]

Please read forum rules - see links below

Your thread title is Invalid