Multiple if checking condition more than one

[Jitendra J Dixit]

Respected Sir/Madam,

Pay ________Input
City Grd ____Input
CCA __?___Result
Pay Range City Grade
A1AB1B2
<3000 90654525
3000 - 4499 125956535
4500-5999 20015012065
6000> 300240180120
Pay and City Grd are the Inputs
the result should be displayed at CCA Boxi..e at _?_
E.G.s
1) if your pay is 1000 and city grd is B2 then CCA should be 120
2) if your Pay is 4500 and City Grd is A1 then CCA should be 200
Formula must check total 4 condition of Payrange and 16 conditions ( 4 condition per pay range ) of the City Grade


Pl help me in this regard. I got stuck what to be used in formula, is it if, multiple if, Hlookup, Vlookup, Index, Match functions, Bit confused and depressed with self, asking for help.
Thanks in advance,
Also I am unable to get into your forum to ask my query
In anticipation,

Jitendra Dixit, India
jjdixit [at] gmail [dot] com
+91-9370902555

 

[Syedali]

Respected Sir/Madam,

Pay ________Input
City Grd ____Input
CCA __?___Result
Pay Range City Grade
A1AB1B2
<3000 90654525
3000 - 4499 125956535
4500-5999 20015012065
6000> 300240180120
Pay and City Grd are the Inputs
the result should be displayed at CCA Boxi..e at _?_
E.G.s
1) if your pay is 1000 and city grd is B2 then CCA should be 120
2) if your Pay is 4500 and City Grd is A1 then CCA should be 200
Formula must check total 4 condition of Payrange and 16 conditions ( 4 condition per pay range ) of the City Grade


Pl help me in this regard. I got stuck what to be used in formula, is it if, multiple if, Hlookup, Vlookup, Index, Match functions, Bit confused and depressed with self, asking for help.
Thanks in advance,
Also I am unable to get into your forum to ask my query
In anticipation,

Jitendra Dixit, India
jjdixit [at] gmail [dot] com
+91-9370902555

Please check the attached file.

 

[Jitendra J Dixit]

Please check the attached file.

Thanks Dear. Thank You Very Much.
Well I was trying exploring each condition with nested if.
If possible, pl tell me in lieu of the table how would it be done.
thanks again.
J J Dixit

 

[Syedali]

Thanks Dear. Thank You Very Much.
Well I was trying exploring each condition with nested if.
If possible, pl tell me in lieu of the table how would it be done.
thanks again.
J J Dixit

What your expectation. like your requiring in different way or what???