Excel Teacher

Free Training Online - How to Do Stuff In Microsoft Excel

Excel Teacher site navigationSkip to content
  • Home
  • Using ExcelGeneral tips, discussion, and insight on how to get the most from the Excel interface and main features
    • Files and Data Management
    • Ribbons and QAT
    • Formatting
    • Viewing
    • Shortcuts
    • Status Bar
    • Developer
    • Backstage
  • Functions
    • Basic Arithmetic
    • The LogicalsLogical formulae – if, is, not
    • Text
    • Lookups and References
    • Date and Time
    • Advanced Maths
    • Financial
    • Other Advanced Functions
  • Charts & Graphs
    • Standard
    • Advanced
    • Custom Charts
  • Pivot TablesThe All Powerful Pivot Table
  • VBA
    • How To
    • Recording Macros
    • Code Library
    • Add-Ins
  • Information
    • About Us
    • Comments and Moderation
    • Links
Search
  • Excel Teacher Facebook Page
  • Excel Teacher Twitter Feed
  • Excel Teacher Youtube Channel
  • Excel Teacher RSS Feed

Category: Lookups and References

Multiple-Column-VLOOKUP

VLOOKUP With 2 inputs and 2 lookup Columns

How To VLOOKUP with 2 Inputs and 2 LOOKUP Columns Every now…

Continue reading "VLOOKUP With 2 inputs and 2 lookup Columns"…
13 Feb 2018

The CHOOSE formula. When IF Formulas get too complex

If you are new to the CHOOSE formula, it could change your…

Continue reading "The CHOOSE formula. When IF Formulas get too complex"…
29 Jan 2016 Comments: 0

INDEX, MATCH, and INDEX(MATCH)

VLOOKUP (Pronounced V Lookup, not vloo-kup, in case you were wondering) is…

Continue reading "INDEX, MATCH, and INDEX(MATCH)"…
15 Jan 2016
1 2 »
© 2023 Excel Teacher. Back to top ↑
  • Excel Teacher Facebook Page
  • Excel Teacher Twitter Feed
  • Excel Teacher Youtube Channel
  • Excel Teacher RSS Feed