ExcelBanter - IF / ISBLANK

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF / ISBLANK (https://www.excelbanter.com/excel-discussion-misc-queries/257168-if-isblank.html)

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

"Missile" wrote in message
...
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