Match 2 columns then return valu in the 3rd column

[StashSoup]

I have 3 columns of data in Sheet 1. Column A is SKU's, column B is WH's, and column C is a number. Column A has duplicate values, because a SKU exists in multiple WH's.

In Sheet 2 - Column A is the SKU and row 1 is the WH. I need the table poplated with the number from sheet 1.

I know there is aformula for this but i can't seem to get any of them to work. Not INDEX or MATCH or VLOOKUP.

I don't know how I can show a screen cap of the tables??!! So i hope i explained them perfectly.

 

[StashSoup]

so i need to make those constants.

 

[StashSoup]

i got it!!
thanks so much for your help!!

how can i close this thread or award points?

 

[T. Valko]

i got it!!
thanks so much for your help!!

Good deal. Thanks for the feedback!

how can i close this thread or award points?

I don't think they (we) do points here.

There's no specific way to "close" a thread. Your response that the problem is solved is enough to consider the thread closed.

Good luck!