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

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

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