Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FORMULA FOR EXPERT, PLS MAKE THIS WORK
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
FORMULA FOR EXPERT, PLS MAKE THIS WORK
It might be NG wrap-around
=VLOOKUP(D6{"Fusion",15;"Openzone",35.7;"Switch",5 7;"Voip",7.8; "Maintanance",145;"CNE",34.7;"RCF",53;"CNI",7.8;"F eatureline 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 xxxx in the email address with gmail if mailing direct) "Moh" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
FORMULA FOR EXPERT, PLS MAKE THIS WORK
It's continental Excel Blue, they use ; for the separator.
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Blue Aardvark" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
FORMULA FOR EXPERT, PLS MAKE THIS WORK
It might be too late to implement, but with 20+ item list you might
consider either doing the vlookup to a seperate sheet or replacing with a custom function using a select...case as either would be easier to maintain/update price changes in one place than each individual cell. "Blue Aardvark" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add to this formula to make it work | Excel Worksheet Functions | |||
Can't make the division work in my formula | Excel Worksheet Functions | |||
Can's work this out, probably easy for an expert! | Excel Discussion (Misc queries) | |||
FORMULA FOR EXPERT, PLS MAKE THIS WORK | Excel Programming | |||
How do I make this formula work =if(a1=(b10:b20),"good","bad"). | Excel Worksheet Functions |