Hi! I have cells with long descriptions of products in them. I need to extract the language these products are produced in. I'm hoping to have a formula that can look in column I and see if the words "Spanish", "English", "German","Italian", etc are in the text string and then put the language (ie "Spanish") in column J. I've been trying to research it on the web and I think I need an Index/Match sort of formula, but I can't seem to get it right. I have tried placing a Vlookup table on Sheet2, $A$1:$B$9, but I seem to be getting nowhere. Can anyone help me out? Much thanks!