Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Building Formulas
I am trying to build a formula where I can have one input cell and have the
formula look up that value in a table and provide a corresponding value. Example: Someone is going to buy 30 widgets and there are discounted rates depending on the number of widgets purchased. I want to be able to put in 30 and have the formula look up that number and give me the corresponding rate. |
#2
|
|||
|
|||
Building Formulas
Vlookup. See:
The explanation: http://www.officearticles.com/excel/...soft_excel.htm The tutorial: http://www.officearticles.com/tutori...soft_excel.htm ************ Anne Troy VBA Project Manager www.OfficeArticles.com "Shawn K" <Shawn wrote in message ... I am trying to build a formula where I can have one input cell and have the formula look up that value in a table and provide a corresponding value. Example: Someone is going to buy 30 widgets and there are discounted rates depending on the number of widgets purchased. I want to be able to put in 30 and have the formula look up that number and give me the corresponding rate. |
#3
|
|||
|
|||
Building Formulas
=vlookup(num_widgtes,lookup_table,2,false)
where the lookup table is structured as number in one columna, rate in the second. -- HTH RP (remove nothere from the email address if mailing direct) "Shawn K" <Shawn wrote in message ... I am trying to build a formula where I can have one input cell and have the formula look up that value in a table and provide a corresponding value. Example: Someone is going to buy 30 widgets and there are discounted rates depending on the number of widgets purchased. I want to be able to put in 30 and have the formula look up that number and give me the corresponding rate. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
locking formulas?? | Excel Discussion (Misc queries) | |||
Problem with named formula's | Excel Worksheet Functions | |||
Building a table with formulas rather than a macro | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |