Excel Forum
Similar Content
SUMIF - Sum Values Based on Criteria in Excel
Tutorial: The SUMIF function allows you to sum values based on a single criteria. This function wor...
IF() Statement Function in Excel - How to use it
Tutorial: The IF statement is a simple yet powerful tool. Today we will go through how the IF funct...
AND Function - Check if All Arguments are True
Tutorial: The AND function in Excel checks if every argument you put in it evaluates to TRUE.  If e...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




Excel Magic Trick 451: Prefix Lookup & White and Greater Than 15 lbs Lookup


Learn about some common confusion between lookup and data extraction. See the LEFT and TRIM functions and adding zero to convert text to a number create the criteria for lookup, and see how sorting and copy and paste will help to avoid large array formulas.





Got a Question? Ask it Here in the Forum.