I need to find part of string in cell a2 to column D on sheet2.
just like Vlookup i want to find part of string in next sheet and corosponding value in next column. as
column A on sheet 1 has following value
if these string exist in column D on sheet2...