Excel Formulas

SMART EXCEL

Advance Excel formulas / UDFs and Tricks 👨‍💻

• LOOKUP for multiple columns
• LOOKUP on multiple rows
• LOOKUP for unmatched items (Partial String in Lookup value, Full string in Table Array)
• LOOKUP for unmatched items (Full String in Lookup value, Partial string in Table Array)
• LOOKUP for multiple criteria's
• LOOKUP for multiple matches
• 2D Lookup
• Reverse Lookup
• Get Last row
• Get Last column
• Fill blank cells in range
• Fill down multiple cells
• Match positive and negative numbers
• Insert formulas in MS Word / Outlook
• Apply formulas on colored cells
• "SEARCH" function with "OR" condition for multiple texts"
• "SEARCH" function for multiple texts ("AND" condition)
  
• Formula to extract sheet name in Excel
• Insert comment inside a formula
• Reverse a text in Excel
• "FILTER" formula for text contains
• VBA codes for filepath