VLookUp
This is what VLookUps stand for
Vertical Look Up
What C means in CARE
Concentrate
The amount of cities COOP is based in
6
The two options you can insert a Pivot Table on Google Sheets
A New Sheet or Existing Sheet
Another term for test
Exam
The title of the movie about Carl Fredericksen, a 78-year-old balloon salesman, who's dream is to tie thousands of balloons to his house and fly away to the South American widerness (not VLookUp related)
Up
What A means in CARE
Ask
The amount of tracks that COOP offers
4 (but I'll also accept 3)
The field that you place the data you want to analyze or summarize
Values
Attempt to lesson the blame; seek to defend or justify
Excuse
This is the value you want to search for, like the name of a product, an ID number, or a student's name
The Lookup Value
What R means in CARE
Review
The year COOP was established
2014
The 4 Fields of a Pivot Table
Rows, Columns, Values & Filters
Cease to be valid, typically after a fixed period of time
Expire
An example of when a VLookUp would be used
*Captain validates the answer
What E means in Care
Exercise
The 3 Pillars of COOP
Head, Heart and Hustle
The field that helps you choose a specific criteria from fields to control which data is included or excluded from the pivot table
Filters
The branch of government charged with the execution and enforcement of laws and policies and the administration of public affairs
Executive Branch
An alternative to Vlookups and especially valuable if you need to lookup values on the lefthand column and if the data is frequently restructuring
Index Match
The popular trend of lying in a facedown position, sometimes in an unusual or incongruous location
Planking
The 4 colors on the COOP logo (don't make it too complicated)
Red, Yellow, Green, Blue
The formula for specifying what the pivot table will analyze
Name of the Sheet + Columns
The card(s) that Yugi used to defeat Seto Kaiba on episode 1 of Yugioh
Exodia the Forbidden One