In the excel, I need to compare Only portion of text in two different columns and return the value in third columns. say example One column having text of asdf12345 and 2nd column having text of asdf1458. u see in this example, first 5 characters are matching so formula has to compare and return first five value in third columns.
Please anyone help me to sortout this issue. and I tried Vlookup its not sutable for this case.