Use a function : =IF(AD3="","",VLOOKUP(AD3,Table!$E$2:$G$450,3,0)), return
value in cell AE3 e.g. = 03

My problem: Try posting this value to another cell using this function:
=IF(AE3<10,IF(AE3="","","50-0"&AE3&"-"&AB3&"-790-50026-0000"),IF(AE3="","","50-"&AE3&"-"&AB3&"-790-50026-0000"))

The return value always truncated the preceeding zero if I do not use the
last function

I I know this is not proper. Any good suggest from the Pro thanks.