Forum Discussion
Solved
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.
mtarler, when sheet is opened Xlookup formula in billing sheet turned into #name error. =_xlfn.XLOOKUP(SUM(Table2[[#Headers],[Amount]]:[@Amount])-[@Amount]+0.1,receipts[cumulative],receipts[unique ID],,1)
How can I solve this?
Thanks for the support.
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.
- Thanks mtarler, It worked succesfully.