It was superb khalidHi Ratan Bhushan,
I have modified your sheet for getting better result.
See Sheet2
But why we have used FALSE with hlookup, please to advise Khalid...Hi Ratan Bhushan,
I have modified your sheet for getting better result.
See Sheet2
Nicely tricked to get quarter nos.Hi Ratan,
Yet another option:
Formula in I6 to choose quarter number.
Formula in I7 to give result.
Regards,