View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
44judester 44judester is offline
external usenet poster
 
Posts: 4
Default multi-level indexing?

Variables from which to choose: Month, Store#, Type (Fruit or Veg), Color

Table looks like this:
Fruit
Vegetable
Month Store# Red Green Orange Red Green Orange




The data is the inventory of red fruits, green vegetables, etc in each store
at the end of each month.

What does my formula look like to lookup that inventory volume for a given
set of variables?