Excel sheet:

https://imgur.com/7UwGWL0

1. How do i find how many stores achieved a Tier 4 performance based on their January revenue?

2. Tier 5 perfomance based on February revenue?

3. How many stores achieved a Tier 3 or better performance based on their October revenue?

4. Assume we want to look up the revenue for March (cell AH11) by typing different Store Key numbers (cell AG11). How would the formula look like in cell AH11?

5.Assume we want to look up the number of employees (cell AI11) by typing different Store Key numbers (cell AG11). How would the formula look like in cell AI11?

6. Assume we want to look up a stores phone number (cell AJ11) by typing different Store Key numbers (cell AG11). How would the formula look like in cell AJ11?