Why Vlookup isn't working

[rdev]

I have this formula in a column
=IF(ISERROR(VLOOKUP(B192,ConsoTB!A:C,3,FALSE)),0,VLOOKUP(B192,ConsoTB!A:C,3,FALSE))
Whilst it is working for all items found in the sheet ConsoTB , it is not working for few matches even when the match exist in the sheet ConsoTB..
What could be the reason !!

 

[jbeaucaire]

If the formula "mostly" works and randomly doesn't, then it got to be a problem with the data. No match means the cell your 'matching' to isn't what it appears to be, or the data has hard to spot variances.

 

[Richard Schollar]

Duplicate:

http://www.mrexcel.com/forum/showthread.php?t=378029