I am not exactly sure how to go about this, I have multiple conditions that need to be meet before even returning the values.
I though I would have to use and array but wasn't exactly sure how to go about doing so.
The conditions that need to be meet are: Date, Dept, and Item Number weather or not the Item is custom or not. The item needs to be detirmend by part number containing a C sufficx.
Basicly If dept = 1 and date = current day and part number contains "C" sufficx. Then On sheet1 needs to return values back starting in a3 I would like the date for the order, b3 the order number, c3 part number, and d3 the qty for that order for that current day.
Bookmarks