One way:

A10 = pages
B10 = Qty

=INDEX(B2:E4,MATCH(A10,A2:A4),MATCH(B10,B1:E1))

If pages and/or Qty is lower than the lowest value of the table you'll get
#N/A

For example: 50 pages or a Qty of 75.

Biff

"Sum Limit and marking" wrote
in message ...
What would be the best formula to use for the following task:

I have a list of prices, organized by pages and quantity:

Qty 100 200 300 400 .....
Pages
64 $ $ $ $
96 $ $ $ $
128

What formula would allow me to retrieve pricing by Pages. For example I
want to see what the prices would be for pages of 64's?