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.



.