Hi,

I am new to the forum and would apreciate some help / guidence if possible.

I have a scnario where i have 2 sheets, and in the first sheet (Data) i want to return a value to cell D3 from an orderbook in orderbook tab.

Data Tab: I need to match a part number in B3 and year in D1 and Month in D2 then match these to values in orderbook tab and return the value.

I have attached an example for reference, hopefully someone can make sense of this, much appreciated for any help.

Excel 2007