I have two lists that I need to reconcile, one is the list of invoices that were sent in for processing (manually entered data) and the other is the financial system's record once the invoices are processed. We want to make sure everything gets processed and that everything matches. I want to cross reference four different columns as there is no one unique identifier (i.e. each invoice is coded to multiple account codes, etc.). I am having success with this formula:
=SUMIFS(Table1[Row],Table1[Vendor],F2,Table1[Invoice Number],H2,Table1[Account],L2,Table1[GL Amount],U2)
But I would like to make the Row Numbers non-numerical (i.e. instead of 1,2,3, and I want it to be A1, A2, etc. Which throws off the SUM part of this equation.
Any ideas?
=SUMIFS(Table1[Row],Table1[Vendor],F2,Table1[Invoice Number],H2,Table1[Account],L2,Table1[GL Amount],U2)
But I would like to make the Row Numbers non-numerical (i.e. instead of 1,2,3, and I want it to be A1, A2, etc. Which throws off the SUM part of this equation.
Any ideas?