Excel Forum
Similar Content
How to Use the IF Function in Excel
Tutorial: The IF statement is a simple yet powerful tool. Today we will go through how the IF functi...
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...
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 ev...

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.