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...
How to use the Vlookup Function in Excel
Tutorial: Full explanation of the Vlookup function in Excel, what it is, how to use it, and when you...
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 for...

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.