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. . |
All times are GMT +1. The time now is 03:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com