Formula help please

[aparvez007]

Hi Ninja's

I want 1 formula help I have dropdown list in C2 and I have data M3:N38.
I colored red my out put in uploaded file.

Thanks

pAvi

 

[Debraj]

Hi Pavi,

Please check the attached..

 

[aparvez007]

Thanks Deb,
Exactly what I want.

pAvi

 

[aparvez007]

Dear Debraj,

Model 15 is not showing when I select R1 in C2.


pAvi

 

[Debraj]

oops My fault..

Please check now..

 

[aparvez007]

Thanks Debraj,

I tried my self to correct but fail.

Thanks again.

pAvi