• 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

    Hui...

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

VLOOKUP

Adarsh S

Member
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
 

Attachments

bosco_yip

Excel Ninja
Try this,

in G2 formula copied down :

=IFERROR(VLOOKUP(0+F2,$B$2:$C$118,2,0),"")

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

pecoflyer

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
 
Top