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
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