Search code examples
excelrangeformulacellvlookup

Is it possible make up Formula in Excel to Find substring in range cells and return the finded cell's value?

is it possible to find substring from second column in first column and insert in third column like that (vlookup doesn't):

Column values What find This is found
First eco Second
Second irst First
Third eond Don't find
Solution

  • That would be possible using VLOOKUP. If everything was pasted in Excel as is (with headers) the formula displaying Second would be:

    =IFERROR(VLOOKUP("*"&B2&"*";$A$2:$A$4;1;FALSE);"Don't find")

    You can drag it down and it will be good for the other ones also, if it doesn't find the value it will create an error which is catched by the IFERROR and thus showing Don't Find instead.