View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vance K[_2_] Vance K[_2_] is offline
external usenet poster
 
Posts: 3
Default Index lookup with multiple match criteria

I have two tables. one that is inventory related and another that is
forecast related. I need to tie the inventory data to the forecast data.
The issue I have is that I have the sku number for 13 different regions. How
do I develop the index/match function so that it looks up the data that
matches the region and the sku?