Try something like this:

With
Sheet1!A1:Z100 containing your pricing table

then...on Sheet2

A1: (a page value)
B1: (a quantity)

This formula finds the Page referenced in A1 and returns the value under the
Quantity referenced in B1
C1: =VLOOKUP(A1,Sheet1!$A$1:$Z$100,MATCH(B1,Sheet1!$A$ 1:$Z$1,0),0)

Is that something you can work with?

Note: the formula is looking for exact matches.
Is there any chance that the quantities may be non-listed values?

***********
Regards,
Ron

XL2002, WinXP


"Sum Limit and marking" wrote:

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?