31 August 2013
REF will comes when range is shorter than what column reference you have made or earlier reference data is deleted.
you can also refer your formula with below mentioned link https://www.caclubindia.com/share_files/top-10-excel-formulas-for-aspiring-analysts--54186.asp#.UiHn8jZHJXY