Skip to content
sparrowsolutions.ca
  • Home
  • Training
  • Contact Us
  • Blog
  • Privacy Policy
  • Toggle website search
Menu Close
  • Home
  • Training
  • Contact Us
  • Blog
  • Privacy Policy
  • Toggle website search

Monthly Archives: January 2020

  1. Home>
  2. 2020>
  3. January

VLOOKUP vs INDEX MATCH

  • Post author:sparr652
  • Post published:January 17, 2020
  • Post category:Excel tips

VLOOKUP vs. INDEX(MATCH) to look up related information When working with spreadsheets it often happens that you want to look up related information that is already stored somewhere else, whether…

Continue ReadingVLOOKUP vs INDEX MATCH

About Me

About Me

Tim Easter

After working as a finance officer and in other roles, I am now using my experiences to help others overcome their frustrations with spreadsheets, reporting, and analysis so they can get the results they are looking for.

Recent Posts

  • How to Add Mean (Average), Median, or other calculations to a pivot table column
  • Excel Power Features To Learn
  • Multiple Criteria Lookup Formula, or How to Create Complicated Formulas When Required
  • Separate Data From Reports for Best Results

Recent Posts

  • How to Add Mean (Average), Median, or other calculations to a pivot table column
  • Excel Power Features To Learn
  • Multiple Criteria Lookup Formula, or How to Create Complicated Formulas When Required
  • Separate Data From Reports for Best Results
  • Open Database Connectivity (ODBC) Drivers – freeing data from programs​

Recent Comments

  • Excel Power Features To Learn - Sparrowsolutions.ca on A Key Advantage of Tables
  • Multiple Criteria Lookup Formula, Or How To Create Complicated Formulas When Required - Sparrowsolutions.ca on A Key Advantage of Tables
  • Multiple Criteria Lookup Formula, Or How To Create Complicated Formulas When Required - Sparrowsolutions.ca on VLOOKUP vs INDEX MATCH
  • Elementor #443 - sparrowsolutions.ca on A Key Advantage of Tables

Archives

  • November 2023
  • January 2022
  • September 2021
  • January 2021
  • December 2020
  • May 2020
  • April 2020
  • February 2020
  • January 2020
  • December 2019
  • October 2019

Categories

  • Excel tips
  • Uncategorized

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Copyright - WordPress Theme by OceanWP