Hi,
I am trying to combine the Vlookup, Left and Right function in one cell.
Column F3:F12 contain of number and G3:G12 is type and Column A is a lookup value for last four characters (A3:A14).
I am apply the following formula in C3="K"&LEFT(VLOOKUP(RIGHT(--$A3,4)&"*",$F$3:$G$12,2,0),2)...