When using this formula =IF(ISBLANK(B2)," ",VLOOKUP(B2,D2:E50,2,1) I am
getting ethier the #N/A error or incorrect data when cell B2 has a value
starting with a 0, eg 07934.
cannot change this as they are Part Numbers and require the 0.

Any suggestions?

Thanks