Return value with using Excel function

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

Hi!

I think you probably have a format mis-match.

The value returned by your lookup formula, 03, is that a
text value or a number value with a custom format that
uses the leading zero?

If 03 is really a text value then:

=IF(AE3<10 = FALSE

If it is really a numeric value formatted with a leading
zero then yes, the leading zero will be truncated in a
formula unless the target cell is also formatted the same
because the true underlying value is 3 not 03.

Check and make sure all your cell formats are the same in
your lookup table.

Biff

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