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