Quote:
Originally Posted by trebor200
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
|
Hi,
This is easily done using INDEX and MATCH but it would rely on a slight change to your spreadsheet.
Rather than having just a month in row 2 and a year in row 1, if you combined them so the date in B2 on the orderbook tab showed as Jan-12 and all date cells followed that format, including the date cells on the data tab. Would that be suitable for you?
If so I will show the formula you need. If not I will have another think. :)
Similar Threads
Threaded Mode
