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

Category:

Education

Tags:

• Excel
• VLOOKUP
• function
• formula
• IF
• excelisfun
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[PrimeInstruction]

With excel I'm trying to generate Spanish sentences that consist of 3 parts; subject, verb, direct object (ex. You teach Excel). Using IF functions, I'm successfully creating sentences with multiple subjects, dozens of verbs & hundreds of DO's. But some don't make sense (ex. the dog reads carrots), so is there some way in Excel I could refine my functions or should I be using something else entirely. I'd gladly pay you for a phone tutorial. Let me know.

[ExcelIsFun]

@PrimeInstruction , I do not know, try:

mrexcel [dot] com/forum

[PrimeInstruction]

4:02 of this video provided me the long-awaited and much searched for breakthrough that I needed to make an incredible spreadsheet for my Spanish students. Thank you...very well done.

[ExcelIsFun]

@PrimeInstruction , I am so glad that the videos help and may help you teach more people about the power of Excel!

[anthonypblackburn]

I'm doing some simple accounting involving data from three worksheets. Is Vlook up the right function to use to bring the data to the fourth worksheet where the math will be completed?

Thanks for all the hard work

[ExcelIsFun]

@anthonypblackburn , sure. Try these videos for more about VLOOKUP:

Highline Excel Class 40: VLOOKUP 11 Unusual Examples

[ema1991ish]

HIJO DE PUTA TRADUCILO A CASTELLANO

[pangjokhang]

thanks alot

[pavel2358]

this series of excel classes is a great find! Thanks for recording them, I'll be back here for sure!

[ExcelIsFun]

You are welcome!