Missing Leading Zero In Result of Loopup Formula

[Mohamedazees]

Dear Sir,
Please Help us to resolve the Issue:-
While using the Loopup formula in Excel it doesn't Paste the value that contains Leading Zeros

For example, I looked at the result value of 0095, but the formula gives the result of 95. How can I avoid this issue?
The formula I am using is given below for your reference.

"=IFERROR(VLOOKUP([@GRT],ITC_2B,5,FALSE),IFERROR(VLOOKUP([@GRD],ITC_2B[[GRD]:[ITC Availability]],4,FALSE),IFERROR(VLOOKUP([@GDT],ITC_2B[[GDT]:[ITC Availability]],3,FALSE),IFERROR(VLOOKUP([@RDT],ITC_2B[[RDT]:[ITC Availability]],2,FALSE),""""))))"

 

[bebo021999]

Maybe try to format cell with formula as "Text"?

 

[Mohamedazees]

Maybe try to format cell with formula as "Text"?

No use it will paste whole formula

 

[Alex Blakenburg]

It sounds like your original data "is a number" with a custom format of 0000.
You will either need to apply the same custom format ie 0000 to the cell(s) with the formula or convert it to text by wrapping your formula inside =Text(Your_Formula, "0000").
If you pick the latter just be aware that it will no longer behave as a number but will be treated as text.