How would you use VLOOKUP/XLOOKUP, INDEX/MATCH, Pivot Tables, and nested IF statements in a financial analysis workflow?
