Forum Discussion
Need formula to track unpaid bills
Hi, is there any formula in excel or technique to place bills existing in another sheet to place under receipt and remaining bills under the 2nd receipt and so on.
Rizwan_Hussain Ah, you must have an older version of Excel that doesn't recognize XLOOKUP. I have changed it to use INDEX( MATCH () ) combo in the attached.
11 Replies
- We really need more information and a sample sheet/workbook would help a lot.
That said if you have a list and a criteria then on another sheet you can use the FILTER() function to show all the items on the list/table that match your criteria. (you can also use pivot tables or power query)mtarler thanks for the response.
Sheet A contains list of receipts from customer and sheet B contains number of bills invoiced to customer. Problem is that there is no common identifier in both sheets. I want to place the number of bills from sheet B against receipts in sheet A upto the receipt amount. Sample are attached below;
Rizwan_Hussain I still don't think we have enough information. I took a stab at it and made an assumption that the bills were in order of the receipts and used the cumulative totals but I don't think that is the case. Here is the attachment but i think we need more information on HOW you expect the items to get matched up.
