I am creating a net-worth calculator in Excel. I am planning to enter the bank and equity details once a week. I want to know the change in my portfolio compared to the last entry using a function. I can write a VBA code to search for the previous value for a particular category but I want to know if XLookup or something else can help me.