Hi,
“QOH by Date" tab is my spreadsheet that lists all stock items and their quantity on hand for each day in October labeled by the column headers.
“Request Date” tab lists all items that were back ordered in October. “Request Date" tab lists the item #(Column C), the
Transaction Date(column H) and Actual Ship Date(Column I).
Looking at the example items on tab "Request Date" you'll see 3 different item #s (column C) listed on several unique lines.
From the "Request Date" tab, I'd like to match the Item# (column C) and Transaction Date (column H) to the Item #(column A) and the Header Dates on the "QOH by Date" tab. I'd like the formula to be in column M "QOH" (Request Date tab) to return the listed Quantity on Hand when the item# and transaction date matches. I provided an example of what the output should look like on the "Example" tab highlighted in yellow.
Any help is greatly appreciated!
Bookmarks