Hello. Is it possible in Excel to replace words in a range of cells with different words that I've put in another column? Here is a simplified example:
example.png
Here I'd like to replace cells from E5 to H5 based on the two columns on the left. So that "apple" is replaced with "socks", "pear" with "shoes", "melon" with "skirt" and "pineapple" with "shoes".
I hope it's not too trivial. I couldn't work that out. In my project the data is of course more complicated but I think it boils down to just this.
Thank you very much!
Bookmarks