I have cells with numbers like this, 012345678 or 001234567, I formatted all
cells with this function =text(cell,"000000000") so that the zeros are not
cancelled,which is good,my problem was this:
a1=012345678 ,b1=012345678, c1=Shop Stock.
=if(a1=b1,"yes","no") the result was yes.
=if(isna(vlookup(a1,b:c,2,0)),"????",vlookup(a1,b: c,2,0)) the result was
???? and it should be Shop Stock !!!!!!
Could someone help,
Thx