I have in column A a list of numbers 1 to 10
I have in column B a list of numbers eg £31.26, £61.36, £26.45, £39.34 etc.
I want to input into cell c1 a number which is listed in column A and get the corresponding number to appear in cell D1.
A B C D
1 1 £31.26 3 £26.45
2 2 £61.36
3 3 £26.45
4 4 £39.34
5 5 £20.35
Thanks