You Tubers Love Excel6: VLOOKUP and Custom Data Validation


Home \| SCREENCAST FORUM \| Search Screencasts \| MEMBERS

ExcelIsFun

See when the IF function is not efficient to use.

Instead we will use the VLOOKUP function and a logical True/False Data Validation formula to calculate late account fees. See how to use a True False formula for Data Validation

Then use that Data Validation and the VLOOKUP function to create a much more efficient formula than the IF function could give us! See how to create mutually exclusive categories to avoid trouble with the IF and VLOOKUP functions.

Screencast Tags

Colle, Community, Data, Error, Excel, False, formula, function, Gel, Girvin, Highline, logical, message, Mike, True, Validation, VLOOKUP

Search More Screencasts

Share Screencasts

Digg

Del.icio.us You Tubers Love Excel6: VLOOKUP and Custom Data Validation

Del.icio.us Reddit You Tubers Love Excel6: VLOOKUP and Custom Data Validation

Spurl

Squidoo

Yahoo

Google

SocializeIt You Tubers Love Excel6: VLOOKUP and Custom Data Validation