You have a grid of English words in Sheet2. In A1 of Sheet1, you have been given a word. You need to create a Hyperlink through formula in B1 of Sheet1. The Hyperlink which says "Take to the Word – Discover" if the word was Discover in A1. "Take me the Word – Pretty" if the word was Pretty in A1.
You can download the worksheet related to this challenge from Challenge 44 – Hyperlink to a cell in another worksheet by specific text (not cell number)
The solution to above challenge will be published after a month i.e. on 04-Jul-16.