In this video you’ll learn how to set up the Excel template that Analytics Canvas will be writing reports to. Table of Contents
Search Results for: excel
Excel’s INDEX MATCH Alternative To VLOOKUP For Marketers [VIDEO]
Last week’s #FunctionFriday video tutorial covered VLOOKUP tips and techniques for marketers. This week’s video explores the INDEX MATCH alternative to VLOOKUP. Why would VLOOKUP need an understudy? Because VLOOKUPs require that the lookup column be the far-left column in your lookup data set (aka the table_array argument). The INDEX-MATCH dream team doesn’t have that […]
How To Find Text Within Text In Excel #FunctionFriday
Update: Based on questions I’ve received, I added the Misc Notes section to the end of this post. Continuing with our #FunctionFriday series, today we’re going to explore how to use the IF, SEARCH, and ISNUMBER functions together to find text (aka a string) inside other text for classification purpose. What Excel really needs is […]