Thread: lookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sum Limit and marking Sum Limit and marking is offline
external usenet poster
 
Posts: 14
Default lookup

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?