Back in March I did a post on three marketing uses for the OFFSET function. But, truth be told, I avoid the OFFSET function like the plague. The reason is that it’s very unstable and can bring large Excel files to their knees. Why? Every time you modify the file the OFFSET function takes that as […]
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 […]