Hi

For creating your dropdown lists, take a look at Data Validation on
Debra Dalgleish's site

http://www.contextures.com/xlDataVal01.html
and for Dependent dropdown lists for your pare size
http://www.contextures.com/xlDataVal02.html

On your pricelist sheet (Sheet1) I assume that
Size will run down column A starting at cell A2, and that Type will be
in Row 1 starting at B1, with corresponding prices being arranged in the
grid defined by these rows and columns.
For the purpose of this exercise, I am assuming 10 sizes from A2:A11 and
4 types from B1:E1

On your Sheet2 I am assuming you are inputting paper choice in cell A1
and Size in B1
In C1 enter
=INDEX(Sheet1!$A$1:$E$11,
MATCH(B1,Sheet1!$A1:$A11,0),
MATCH(A1,Sheet1!$A$1:$E$1,0))

Debra also has lots of information on Index/Match as well on her site at
http://www.contextures.com/xlFunctions03.html


--
Regards

Roger Govier


"fLy" wrote in message
...
Help!
I want to make a record of paper types, sheet size, & their
corresponding
price(sheet or ream), then, in another worksheet, there's a cell where
I will
input/choose which paper type,then on the next cell the sheet size
(which
should only show the size available for the chosen type of paper),
after
that, the next cell or the cell of my choice will output the
corresponding
price. This will seem to be a long explanation for a newbie like me
but
please help me if you can. Thanks in advance.