VLOOKUP returns '#N/A'. Clearly it is not finding a value. If however, I go to the source cell (key)

[sarfraz.khan1985]

VLOOKUP returns '#N/A'. Clearly it is not finding a value. If however, I go to the source cell (key) and press F2 to edit the cell and then press return without making ANY changes, the formula works! With a lot of data this is not practical. Changing the format to number, cutting and pasting as values... all of this doesn't work. It's not a precision issue as turning on the 'as displayed' function on the Calculation tab under options doesn't help.

 

[Hui]

Sarfraz

Firstly, Welcome to the Chandoo.org Forums

Can you post a sample file ?

 

[Khalid NGO]

May be version compability issue

 

[shrivallabha]

I would suggest you check Calculation mode which is in Formulas | Calculation Options. It should be set to Automatic.