VLOOKUP if cell contains a word within the text

VLOOKUP if cell contains a word within the text

Ever had a huge text and want to extract or find a particular word or number in the text. In some cases, it becomes hard to reread the whole text to find out where the word or number is placed within the text. The VLOOKUP command helps a lot in performing such tasks. It enables … Read more