Excel University Blog

Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.

Battle

Battle of Heavyweights: VLOOKUP

By Jeff Lenning | July 24, 2019 |

This is the first post in a series called Battle of Heavyweights. In the series, we’ll use a boxing metaphor to compare VLOOKUP and SUMIFS. Now, as you read the next paragraph, use your best announcer’s voice and be sure to imagine the roar of a cheering crowd 🙂 “Ladies and gentlemen, welcome to the…

Read More
Training Programs
Free Resources

Learn by Email

Subscribe to Blog (free)
!
!
Subscribe
Something went wrong. Please check your entries and try again.

Topics

Battle Breakout Chart ChatGPT CHOOSE CONCAT CONCATENATE Conditional Formatting COUNTIFS Data Model Data Validation Dynamic Arrays EOMONTH External Data FILTER Filters FlashFill Format Get & Transform Hacks Hyperlink IFERROR INDEX INDIRECT Macro MATCH Named Ranges Named References Names Pictures PivotTable Power Pivot Power Query SEQUENCE Sort Spill SUBTOTAL SUMIFS Tables TEXT TEXTJOIN UNIQUE VLOOKUP VSTACK XLOOKUP

Categories