Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i make prices appear automactically
i have a spreadsheet designed for invoicing, my staff enter products via
validation lists, if the item selected is "wood" for example, can the cell next to it automatically enter the price into it. If it possible how can someone give me a simple example. thanks pat |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i make prices appear automactically
Look at this tutorial:
http://www.contextures.com/xlFunctions02.html -- Kind regards, Niek Otten Microsoft MVP - Excel "Patricb" wrote in message ... |i have a spreadsheet designed for invoicing, my staff enter products via | validation lists, if the item selected is "wood" for example, can the cell | next to it automatically enter the price into it. If it possible how can | someone give me a simple example. | | thanks pat |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i make prices appear automactically
Pat,
If you have a table of Products and Prices .. let's call it PriceTable ... then if product is entered in cell a1 then in B1 put: =VLOOKUP(A1,PriceTable,2,0) to return the price. PriceTable in this example is named range on (say) Sheet2 in Columns A & B (A=Product, B= Price). The formula above could be written as: =VLOOKUP(A1,Sheet2!A:B,2,0) To allow for products which are not on the price table (?!) use: =IF(ISNA(VLOOKUP(A1,Sheet2!A:B,2,0)),"No price",VLOOKUP(A1,Sheet2!A:B,2,0)) HTH "Patricb" wrote: i have a spreadsheet designed for invoicing, my staff enter products via validation lists, if the item selected is "wood" for example, can the cell next to it automatically enter the price into it. If it possible how can someone give me a simple example. thanks pat |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i make prices appear automactically
Thanks Niek
VLOOKUP will solve this and many future problems for Thanks Again "Niek Otten" wrote: Look at this tutorial: http://www.contextures.com/xlFunctions02.html -- Kind regards, Niek Otten Microsoft MVP - Excel "Patricb" wrote in message ... |i have a spreadsheet designed for invoicing, my staff enter products via | validation lists, if the item selected is "wood" for example, can the cell | next to it automatically enter the price into it. If it possible how can | someone give me a simple example. | | thanks pat |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i make prices appear automactically
Cheers Toppers
thanks for the simple and pratical advice "Toppers" wrote: Pat, If you have a table of Products and Prices .. let's call it PriceTable ... then if product is entered in cell a1 then in B1 put: =VLOOKUP(A1,PriceTable,2,0) to return the price. PriceTable in this example is named range on (say) Sheet2 in Columns A & B (A=Product, B= Price). The formula above could be written as: =VLOOKUP(A1,Sheet2!A:B,2,0) To allow for products which are not on the price table (?!) use: =IF(ISNA(VLOOKUP(A1,Sheet2!A:B,2,0)),"No price",VLOOKUP(A1,Sheet2!A:B,2,0)) HTH "Patricb" wrote: i have a spreadsheet designed for invoicing, my staff enter products via validation lists, if the item selected is "wood" for example, can the cell next to it automatically enter the price into it. If it possible how can someone give me a simple example. thanks pat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a 3-dimensional plot in Excel? | Charts and Charting in Excel | |||
Can I make formulas more flexible? | Excel Discussion (Misc queries) | |||
How do I make each row add up seperatly? Please make it easy... | New Users to Excel | |||
make hidden window or workbook visible without specify the name | Excel Worksheet Functions | |||
make cell contents equal to null value - not blank, but empty | Excel Worksheet Functions |