Ok Simply...

I have a list of numbers in column A
I have another set of numbers in column C
And descriptions in column D

A B C D
1)1 blank 1 dog
2)2 blank 2 cat
3)3 blank 3 donkey
4)4 blank 4 monkey

What do i want!? - I want a formula in Column B to say If A1=C1 then B1 = D1 'Dog', however i have a huge range with multiple of the same number in A1, but only one of the number in C1 which relates to a description in D, a range..

Thanks in advance!

Jon