list

[gote]

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

 

[Debra Dalgleish]

You can use the VLOOKUP function to return the price for a selected
product. There are instructions in Excel's help, and here:

http://www.contextures.com/xlFunctions02.html

 

[gote]

it doesnt help i awant to chopse from a list product and it shows me this in
other sheet

thx