Looking for solution (vlookup + ?)

[memorex]

Hi guys,

I am stucked at creating a function that would solve my problem.
I have a table excel forum sheet.xlsx where I need to fill in cells marked with "?".
The issue is I need to consider 2 parameters (product no. and warehouse) to get stock level for each product/warehouse.
Standard Vlookup I am familiar with will only returns "first" value...

Can anyone help please? Many thanks! Rado.

[BadlySpelledBuoy]

Put the formula below in cell G5 then copy right and down as necessary.

Please Login or Register  to view this content.

That's one way of doing it.

BSB

[Czeslaw]

Please Login or Register  to view this content.

Remove the union of cells B3-D3.

[memorex]

Dear BadlySpelledBuoy & Czeslaw, many thanks! Both works for me fine, although I am still wondering as I was almost sure VLOOKUP will be included - I have to spend a little more time to understand how provided solutions work - but anyway, many thanks and please close thread.