Menu
Excel AwesomeExcel Awesome
Search
    • About Us
  • Excel Awesome
Excel AwesomeExcel Awesome
3 Posts In

Lookup Functions

Excel Link to VLOOKUP or SUMIF Result
  • Posted in
    • Lookup Functions
    • Text Functions

Excel Link to VLOOKUP or SUMIF Result

  • March 26, 2019
  • 0 Comments

It can be incredibly useful to create a link to VLOOKUP results in Excel®. This is particularly true if you have used VLOOKUP to join data from one table to…

Excel Wildcard Examples
  • Posted in
    • Lookup Functions

Excel Wildcard Characters: The Ultimate Guide + Tips & Tricks

  • March 26, 2019
  • 0 Comments

Excel wildcards got you feeling lost in a sea of data? You’re not alone. Many Excel users struggle with harnessing the power of these special characters to quickly find, filter, and analyze information…

How To Lookup Part of Text in a Cell
  • Posted in
    • Lookup Functions
    • Text Functions

How To Lookup Part of Text in a Cell

  • March 22, 2018
  • 0 Comments

In Excel you may need to lookup just part of the text in a cell. For example, if you have a cell that contains a transaction description and within that…

We’ve been building Excel financial models, dashboards and automating with macros since 1993. On this site you’ll find tips, tutorials and tools for accountants and finance professionals.

© Copyright 2024, All Rights Reserved

    • Contact Us
    • Privacy Policy
    • Website Terms
    • Sitemap