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