Hi can someone help
i have created a spreadsheet to work out how much money people will make
from each product.

the 20 products are all in one cell (f8) in a drop down list format

so for e.g if i went to cell f8 and select a product from it e.g VOIP then
in the cell next to it, it should bring up the price of it.

also if my product has a space in it e.g Featureline 1 Year how do i put
that into the formula? AS IT SHOWS UP #N/A

this is what im using but it only works for the first 4 products.

=LOOKUP(F8,{"Fusion","Openzone","Switch","Voip","M aintanance","CNE","RCF","CNI","Featureline
1 Year","Featureline 3 Year","Featureline 5 Year","Mobile Low Tier","Mobile
Low Tier","Mobile Low Tier","Telephone System","VAS -
StaticIP";15,35.7,57,78,145,34.7,53,7.8,2.5,6.6,5. 67,8.78,1.45,3.4,5.7,7.53})


--
please can you help... its urgent