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.
>
>