How to copy and paste the value corresponding to the matched cel [Closed]

Report
Posts
1
Registration date
Wednesday May 18, 2016
Status
Member
Last seen
May 18, 2016
-
Hello,
A COLUMN CONTAINS VALUES 2, 3, 1, 10. B COLUMN CONTAINS VALUES 22, 1, 2, 36, 24, 10. C COLUMN CONTAINS VALUES 9, 8, 7, 6, 5, 4, 2, 1. NOW A1=2 IS MATCHED AT B3. THE CORRESPONDING C3 VALUE IS 7. NOW, I WANT THIS ANSWER 7 TO BE PASTED AT D1 i.e., POSITION CORRESPONDING TO A1. KINDLY SOLVE MY PROBLEM