Dear Sir, Can we make a formula like Sheet2 Column C5 has complete Invoice number like M1920-0001 Sheet1 Column B3 if put just 0001 then in the same column complete invoice number like M1920-0001 will come.