Home |
Search |
Today's Posts |
#1
|
|||
|
|||
list
i made list of product prices in one sheet
and when ichoose one of the producs i want it to show me the price n the other sheet but the problme is that the nomber of the cell is chaged (beause i am chosig diffrent products ) how an i tell him take the cell under the head of the list thx very important to me |
#2
|
|||
|
|||
You can use the VLOOKUP function to return the price for a selected
product. There are instructions in Excel's help, and he http://www.contextures.com/xlFunctions02.html gote wrote: i made list of product prices in one sheet and when ichoose one of the producs i want it to show me the price n the other sheet but the problme is that the nomber of the cell is chaged (beause i am chosig diffrent products ) how an i tell him take the cell under the head of the list -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
it doesnt help i awant to chopse from a list product and it shows me this in
other sheet thx "Debra Dalgleish" wrote: You can use the VLOOKUP function to return the price for a selected product. There are instructions in Excel's help, and he http://www.contextures.com/xlFunctions02.html gote wrote: i made list of product prices in one sheet and when ichoose one of the producs i want it to show me the price n the other sheet but the problme is that the nomber of the cell is chaged (beause i am chosig diffrent products ) how an i tell him take the cell under the head of the list -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List box not being displayed in second worksheet | Excel Discussion (Misc queries) | |||
Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) | |||
Drop List Referencing | Excel Worksheet Functions | |||
Creating a list from an existing list. | Excel Worksheet Functions |