How to find the value in sale report

[Ratan Bhushan]

Hey frineds

I am uploading a file in which have different quarters, and a list of sales emplyees, I want to search the sales numbers of an employee for different quarters... but I am unable to do so...
Please help..
I am uploading the file.
Thanks

 

[Bhawani]

PFA... i have added updated quarter number below month list.
please check if its same you are looking.

 

[Ratan Bhushan]

Hey, it was awesome, Please describe how did you manage the function to work here, I mean what login you followed ???

 

[Khalid NGO]

Hi Ratan Bhushan,
I have modified your sheet for getting better result.
See Sheet2

 

[Ratan Bhushan]

Hi Ratan Bhushan,
I have modified your sheet for getting better result.
See Sheet2

It was superb khalid
The way you have modified, it leads report to the data where we can make data dynamic.
Hats off to you

 

[Ratan Bhushan]

Hi 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...

 

[Somendra Misra]

Hi Ratan,

Yet another option:

Formula in I6 to choose quarter number.
Formula in I7 to give result.

Regards,

 

[Khalid NGO]

Ratan actually FALSE is exact match type.

 

[Bhawani]

Hi Ratan,

Yet another option:

Formula in I6 to choose quarter number.
Formula in I7 to give result.

Regards,

Nicely tricked to get quarter nos.