Table of contentsList of Top 10 Advanced Excel Formulas & Functions#1 VLOOKUP Formula in Excel#2 INDEX Formula in Excel#3 MATCH Formula in Excel#4 IF AND Formula in Excel#5 IF OR Formula in Excel#6 SUMIF Formula in Excel#7 CONCATENATE Formula in Excel#8 LEFT, MID, and RIGHT Formula in Excel#9 OFFSET Formula in Excel#10 TRIM Formula in Excel