So, in your result, presumably A908 = 0

So,
"D"&right(VLOOKUP(C908,AllCodes!$A$11:$E$824,1),le n(VLOOKUP(C908,AllCodes!$A$11:$E$824,1))-1)

will repalce with a D at the beginning...

"evoxfan" wrote:

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?