Excel 2007 : Getting data from crosstable

Hello

I'm having a bit of trouble with extracting data from a crosstable in excell. Couldn't find any help through google, since I don't quite know how to formulate my problem.

So, my explanation:

I have an EOQ crosstable. In the left column I've got the amount of products sold of 1 category, and in the top row I've got the price/piece. The table is filled with EOQ values, the ideal amount I should produce according the the price/piece and yearly average sales.

\1 (the table)

On the next tab, I need the data extracted. This is where I got stuck. I tried horizontal and vertical search, but I couldn't get the right values.

So when I insert my AP (price/piece) and AFZ (yearly average sale), it needs to crossreference the table, and get me the result I wanted from the table.

To add some difficulty; the table has it's set value, and for example when I insert 70 for AP on the second tab, it needs to jump to 100 in the table, because it's more than the value before it, being 63. The same goes for the AFZ.

I hope this made some sense, and I hope someone can help me out a bit, or atleast help me on my way. I know there's easier solutions, but I want to get to know excel a bit better, and this is the way I want to do it.

Thanks for reading through this!

Chiemel

I know there's easier ways, but I want to get this table thing under control.