Explain how you would use advanced Excel functions like VLOOKUP, INDEX/MATCH, and nested IF statements to clean a disorganized dataset.