Excel Forum
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




YouTubersLoveExcel#28: Complex & Amazing Excel Trick


See how to use the INDEX, RANDBETWEEN, COUNTA, IF, AND, & VLOOKUP functions together to select a random Employee and determine if they have meet the given criteria and they apply Conditional Formatting.

1) See how to select a random employee from a huge list of employees using the INDEX, RANDBEWTEEN and COUNTA functions
2) See how determine if a randomly selected employee meets given criteria with the IF, AND and VLOOKUP functions.
3) See how to add Conditional formatting with a TRUE/FALSE formula
4) See how to use the VLOOKUP function in a TRUE/FALSE formula with a comparative operator.

You will not believe the complexity and amazing result of this Excel Trick!

Formula.





Got a Question? Ask it Here in the Forum.