They need to be ordered. Try VLOOKUP

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

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Moh" wrote in message
...
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","C
NI","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