Microsoft Excel

2 minute read

Excel Challenge 18

Claudia Buckley

Claudia Buckley

Join the Excel conversation on Slack

Ask a question or join the conversation regarding Excel challenges on our Slack channel.

Download your challenge data!

Start working on the Excel challenge with this data workbook.

This Excel challenge promises to be fun! We want to perform a two-way lookup and use that value to output text from a range. 

To get started,

  1. Watch the challenge video. 
  2. Download the Excel worksheet. 
  3. Complete the challenge tasks.
  4. Share your solution, discuss, or ask for help in our Slack channel.

The Challenge

Here’s the scenario: 

The first table on the worksheet carries a 5-day temperature forecast for seven cities around the world. Next to it is the accompanying outlook for each temperature range.

You need to:

  1. Create dropdown lists for the city and day in the input cells, and 
  2. Create formulas that will find the forecasted temperature in the first table, and display the outlook that corresponds to that temperature. 

The tasks are easy to understand, but the solution might require a bit of effort, so get started early! Stumped? Pick up a couple of hints by watching these tutorials.

 

And you can check out our blog for detailed explanations of when and how to use these functions:

Then tune in next week for my solution.

Download your challenge data!

Start working on the Excel challenge with this data workbook.

We hope you'll enjoy working on this challenge!


The Solution


We hope you enjoyed taking part in this challenge!

Stay tuned to the GoSkills Excel Resource hub for more Excel challenges, and check out our range of expert-led Excel courses for all skill levels to further sharpen your skills.

If you enjoyed this challenge, you’ll love our Basic and Advanced Excel course which will help you learn more essential formulas, functions, and practical, real-world Excel skills.

Level up your Excel skills

Become a certified Excel ninja with GoSkills bite-sized courses

Start free trial

Join the Excel conversation on Slack

Ask a question or join the conversation regarding Excel challenges on our Slack channel.

Claudia Buckley

Claudia Buckley

Claudia is a content creator and business skills instructor at GoSkills. If she's not at work, she's probably tackling a genealogy project.