Formula Not working in Work book

I would like to know reason behind below senario.
I opened one work book and put vlook up with some values, formula was not working in that excel sheet. Then i opened another workbook and done same formula has worked fine, is anyone faced same issues with your excel, Could you please say exact reason behind it. ( there is calculation option in formula for Automatic & manual selection, it was selected automatic only)

Thanks and regards