Upload

Loading...

This video is unavailable.

Highline Excel Class 35: IF Function Vs. VLOOKUP Function

Like this video?

Sign in to make your opinion count.

Don't like this video?

Sign in to make your opinion count.

Want to watch this again later?

Sign in to add this video to a playlist.

Uploaded 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...

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Ratings have been disabled for this video.
Rating is available when the video has been rented.
This feature is not available right now. Please try again later.

Loading...

Advertisement
Loading...
Working...
to add this to Watch Later

Add to