IF / ISBLANK

  • Thread starter Thread starter Missile
  • Start date Start date
M

Missile

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
 
Your lookup value is text, and your lookup table has numbers, or vice versa.

Ensure both are text, or both are numbers. Either one will solve your
problem.

As an aside, to display nothing in a cell, you're normally better off to use
"" rather than " ".

Regards,
Fred
 
Back
Top