Assignment Task: Text Functions for Cabin Amenities
The boss wants the Current Rates sheet to indicate whether each cabin has a fireplace and/or a hot tub. Columns G and H have been created to contain that data, but nobody knew how to make text functions, so the columns are empty. Good thing you work here now...
Your task is to create formulas in GZ:H60 of the Current Rates sheet that will analyze the content of 32:861 and display either a "Yes" or nothing ("") to tell the user whether or not that cabin has a particular feature (fireplace for column G and hot tub for column H). Hint: this will require an IF, a SEARCH or FIND, and an IFERROR function.