Jamie Wagler
Member
Please see Sheet3 on the attached file.
I am trying to return the smallest date from Sheet1 and Sheet2 into Columns D and E corresponding with the item list on Column A of Sheet3, but my Index(Match(Small keeps coming back with #REF!???
If possible I would like to assign a ranking ie 1-10 of which item is required on the earliest date. In the case of two items being required on the same date Highest cost (Column B Sheet3) would be the higher ranked item.
I am trying to return the smallest date from Sheet1 and Sheet2 into Columns D and E corresponding with the item list on Column A of Sheet3, but my Index(Match(Small keeps coming back with #REF!???
If possible I would like to assign a ranking ie 1-10 of which item is required on the earliest date. In the case of two items being required on the same date Highest cost (Column B Sheet3) would be the higher ranked item.
