I am in cell D908.
This is my formula:
=IF(E908=" ","
",IF(A908<0,"D"&MID(A908,2,255),VLOOKUP(C908,AllC odes!$A$11:$E$824,1)))
Gives me: X72000
All numbers from column 1 on the AllCodes worksheet begin with X.

I would like it to return: D72000

Is it possible to accomplish this in cell D908 or Do I have to create
another column for the conversion?