It sounds like you want to use =vlookup() or =index(match()).

Debra Dalgleish has lots of notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))
and
http://contextures.com/xlFunctions02.html#Trouble

Nevyn wrote:

I have ten or so pages in a book. on onme page there is the headings to a
sheet called photo stock (item,cat,size,stock,ordered,sold) on another page
called Photo OrderI have the same headings. What I want to do is when I place
a number in Photo Stock Ordered above zero it will copy all the information
from that row in photo stock and place it in Photo Order have tried many
different things but none seem to work can anyone help please.
Nevyn

--

Dave Peterson