Excel 2016 / Auto populate other cells based off two different cells data

I have a sales status report in excel 2016. I am trying to accomplish below - any assistance will be greatly appreciated.

Column B has the Dealer Code
A01 = Is Only Retail
A02 and on... - Each Dealer has their own code

Column R has a Delivery Code
G (Green)
Y (Yellow)
N (Orange)
R (Red)

Column S has the number of days until Installation
IF B1 = "A01" and R1 = "G" Then S1 = "34"
IF B2 = "A02" and R2 = "G" Then S2 = "32"
If B3 = "A01" and R3 = "Y" Then S3 = "17"

Column T has the number of days until Delivery
IF B1 = "A01" and R1 = "G" Then S1 = "26"

See chart below for matrix:

	Install	Delivery	Install	Delivery	Install	Delivery	Install	Delivery
	G	G	Y	Y	O	O	R	R
A01	34	26	17	13	14	10	7	5
A02	32	26	15	13	12	10	5	5

I would advise two sheets - one for your sales table and one for your matrix, then just use an INDEX/MATCH lookup in columns S and T to pull your data from the matrix.

In S2, use:
=INDEX(Matrix!$B$3:$I$4,MATCH($B2,Matrix!$A$3:$A$4,0),MATCH($R2,Matrix!$B$2:$I$2,0)+COLUMN(A:A)-1)

Fill it right into T2, then fill down as far as you need to. See the attachment for a look at what I'm imagining:

This actually is working great!!! Thank you.

So, in the matrix, what if I add additional A##?

Originally Posted by jmyersnc

So, in the matrix, what if I add additional A##?

Glad I could help! You can add additional rows to the matrix, just change all of the matrix references in the formula from $?$4 to $?$5 or whatever the new Matrix range is. If, for example, it goes to A100, then use the following in S2:

=INDEX(Matrix!$B$3:$I$102,MATCH($B2,Matrix!$A$3:$A$102,0),MATCH($R2,Matrix!$B$2:$I$2,0)+COLUMN(A:A)-1)

Good luck!