Here's what I'm looking at:

http://img148.imageshack.us/my.php?i...ventorymv7.jpg

The left image is the summary page. I need a formula in the "Days Out"
column that will look up data in the inventory sheet (right image) and pull
the most current 'actual' inventory count and divide it by the average daily
sales.

Any ideas? Someone gave me a good LOOKUP formula, but it only worked
horizontally and I need this to be vertical.