Copying a data validation list box using an if function.

Is it possible to do this as right now my If function is just copying the value of the list box instead of the actual list box.

Here is my formula


=IF(B6 = "Lg",C46,IF(B6 = "Motorola",D47,IF(B6 = "Nokia",D48,IF(B6 = "Sagem",D49,IF(B6 = "Samsung",D50,IF(B6 = "Sharp",D51,IF(B6 = "Siemens",D52,IF(B6 = "Sony Ericsson",D53, "Please Enter Manufacturer"))))))))



Sorry if its messy or badly done but im new to this thing.

Thanks for the help...