Copying a data validation list box using an if function.

[humphreyscraig0]

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...