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