560 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.
Open the workbook in the above folder. To do this exercise you may find it useful to create the following range names:
If you know about range names, you'll find it useful to use the labels in the top row to create 5 ranges called Plant_Name, Colour, Category, Soil and Price respectively.
Create an XLOOKUP formula to show the colour and price of any plant name you type in to cell H4:
You should look up the plant name in column A, and return the corresponding values in column B and E respectively. Use the fourth argument to control what happens if your plant name doesn't exist.
Now create a formula to fill in these values:
You should be able to create a single formula to give the colour of the plant name entered - this formula will spill over into the neighbouring cells to give the category, soil type and price of the plant.
You may find it useful to create a name for the following range to do this:
To get the formula to spill over, you'll need to reference this block of cells.
If you still have the time and energy, you could try filling in the rest of the formula gaps:
You'll need to use a wildcard for the first part, and specify a search mode argument (top to bottom or bottom to top) for the second.
Save your workbook as Plant lookups, then close it down.
You can find other training resources for the subject of this exercise here:
25 Aytoun Street