Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula problems help please.
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula problems help please.
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Problems | Excel Discussion (Misc queries) | |||
formula problems | Excel Discussion (Misc queries) | |||
Formula Problems | Excel Discussion (Misc queries) | |||
Formula problems | Excel Discussion (Misc queries) | |||
Formula Problems | Excel Worksheet Functions |