I have an excel sheet provided by a customer to communicate their forecast (product numbers left column, due dates in top row, quantities for each product in intersection the two). It has all sorts of extraneous columns and rows (some merged) for keeping internal notes. I'd like to report only part numbers that have an order quantity and the date the quantity is due.
Kind of a vlookup, but the column to report back is conditional (does not = 0) and if true, reports back the value (quantity due), and then in an adjacent cell, report the date (which is at the top of the column) the quantity is due.
I hope this makes sense, kind of hard to articulate.
thanks
Bookmarks