• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.


Adarsh S

For the VLOOKUP formula to work, I need to double click each cell otherwise it shows N/A. If I convert the cell from GENERAL to NUMBER, the VLOOUP results are not being showed. How to overcome this? Pl



Excel Ninja
Try this,

in G2 formula copied down :


Remark : only 49 cells got results, the other return blank.


Active Member
How to overcome this?
First of all remove the manual alignment
You now see col F is text ( left aligned ) and col B are numbers.
Adding 0 to text looking like a number ( or any arithmetic operation for that matter), coerces it to a number ( see post #2) and saves the day