Try this:
Let's say your citeria in G1 and H1
G1 =80
H1 =750
Formuala in
I1
=IF(ISNA(MATCH(H1,A1:E1,0)),INDEX(A1:E5,MATCH(G1,A 1:A5,0),MATCH(H1,A1:E1,1)+1),INDEX(A1:E5,MATCH(G1, A1:A5,0),MATCH(H1,A1:E1,0)))


"Sum Limit and marking" wrote:

I need a formula that can help me do the following:

I have a pricing grid in the following format,

A B C D E
1 500 1000 2000 2500
2 64 $ 5 $ 6 $ 7 $ 8
3 80 $ 7 $ 8 $ 9 $10
4 96 $...............................
5 112 $...............................

The numbers in column A are the number pages
The numbers in row 1 are quantities of books

Is there a formula that would allow me to type in the number of pages, and
quantity, and provide me with the correct pricing? For example, a 64 page
book at a quantity of 500 equals $5. Also if a book contains 80 pages with a
quantity of 750, I need it to give me the next highest cost, which would be
$8. Any suggestions?