Special Use of Lookups

• Intermediate
• 2400
• 2.400 points

Try using vertical lookup instead of if statements

Top Models

• Intermediate
• 1500
• 1.500 points

Calculate the earnings of top models based on scenarios

Employee List

• Intermediate
• 1300
• 1.300 points

Lookup employee information from the employee list based on different parameters

Practice: Date Functions

• Intermediate
• 500
• 500 points

Making more practice by using date functions.

GYM Complaints Sheet

• Unknown
• 900
• 900 points

Master date functions using the complaints data for a gym.

Coffee Shop Price Table

• Unknown
• 900
• 900 points

Create an interactive price table for a coffee shop using various lookups. You'll learn base of VLOOKUP() and HLOOKUP() ...