How to check the contents of a cell in a hum table and replace it if it matches the data from the array?

Question

Google Sheets

There is a table with data that indicates the correspondence of words, for example:
apple yabloko
pear grusha
raspberry malina
and so on ....

how can I make it so that if I have "grusha" written in the cells, then the word automatically changes to the corresponding "pear" "?

Answer 1

1. Give examples of data - without this you cannot get a specific solution
   
2. If you use formulas, then nothing can be "replaced", you can only create a dependent data array with replacements
   
3. If you need to change your data once, use either the menu function Edit - Find and Replace, or scripts
   

Answer 2

You make a button through the tag "a" and "font awesome"

<a href="">Ok let]s go <i class="fa fa-gitlab" aria-hidden="true"></i>
 </a>

style the link

Answer 3

Pseudo element.
https://webref.ru/css/before
https://webref.ru/css/after