Excel Forum
Similar Content
Create a Custom Function in Excel - UDF
Tutorial: How to create a custom worksheet function in Excel. These are called User Defined Function...
Formula to Delete the First or Last Word from a Cell in Excel
Tutorial: Excel formula to delete the first or last word from a cell. You can copy and paste the fo...
VBA IF Statement in Excel Macros
Tutorial: IF statements allow you to make decisions in your Macros and VBA in Excel. An IF statement...
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



Highline Excel Class 35: IF Function Vs. VLOOKUP Function


Topics for this video:
1)See an efficient IF function formula get beat by an even more efficient VLOOKUP function formula
2)See how to build the most efficient IF function formula when there are mutually exclusive categories: Always start at top and move toward bottom, or always start at bottom and move up.
3)Multiple IF functions
4)VLOOKUP is easier to create than an IF function formula
5)VLOOKUP beats IF function Again!
This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109





Got a Question? Ask it Here in the Forum.