# Fix All Excel Errors

  • Home
  • Knowledge Hub
    • Excel Errors Explained
    • Date and Time in Excel
    • Power Query
    • Pivot Tables
  • Articles
  • About Us
    • About Us
    • Privacy Policy
    • Terms and Conditions
    • Contact Us

Archives

Excel-Index Match

INDEX and MATCH – A More Advanced Lookup in Excel

  • August 14, 2022
  • Excel formulas

In the VLOOKUP article, we have looked at some limitations with the VLOOKUP function in Excel. For example, we must start from the leftmost column and look up values on the righthand side. Similarly with HLOOKUP, we must start from the top row and look for values downwards. So if you are looking for a … Continue Reading

  • Latest Posts

    • How to Freeze a Row or Column in Excel
    • Dynamic Dropdown List in Excel
    • Searching for a Value that has Multiple Entries in the Table
    • REPLACE Function – Changing Existing Text with New Text
    • How to Change and Substitute Specific Text in Excel
  • Search

    • Data Validation
    • Dropdown List
    • Excel formulas
    • Formatting Cells
    • Layout and Formatting
    • Macro VBA
    • Password Protection
    • Uncategorized
  • © 2016 All Rights Reserved | Powered by Wordpress | Made with ❤ by Themely