Loading...

Highline Excel Class 35: IF Function Vs. VLOOKUP Function

143,670 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on May 13, 2009

Download Excel file: http://people.highline.edu/mgirvin/ex...

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

  • Category

  • License

    • Standard YouTube License

Loading...

Advertisement

to add this to Watch Later

Add to

Loading playlists...