I am trying to use XLOOKUP function in excel in order to find a value in two ore more different columns placed each one in a different worksheet or workbook.

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.

I am working in a flight manager workbook where a Departure and a Destination airport can be selected. Once the airports have been selected their coordinates are fetched from a different worksheet using an XLOOKUP function.