ExcelBanter - FORMULA FOR EXPERT, PLS MAKE THIS WORK

What about if you put .... ,2,FALSE) instead of ;'s in the formula

"Moh" wrote:

Hi can someone help
IM USING EXCEL XP NOT 2003 and 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 (D6) 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 7.8, the price of it.

this is what im using but it highlights =VLOOKUP(D6 and says there is an
error with the formula.

=VLOOKUP(D6{"Fusion",15;"Openzone",35.7;"Switch",5 7;"Voip",7.8;"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)

PLEASE HELP

--
please can you help... its urgent