Try the below to return a match from col C.....region in col A and sku in
ColB. Adjust the range to suit your requirement

=INDEX($C$2:$C$10,MATCH(1,($A$2:$A$10=region)*($B$ 2:$B$10=sku),0))

If this post helps click Yes
---------------
Jacob Skaria


"Vance K" wrote:

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?