Vlookup/Index Match on multiple items

[c_cha]

If I have a picklist for all twelve months and each month has two variables, how would I created a formula that pulls in one of two variables I want and change based on the month I select?

Example below. If I wanted to pull John February Returns or James March Sales.

Thanks for your help!

 

[kweaver]

Try this (you didn't say where you wanted the result(s)):

Book3 (version 1).xlsb
	A	B	C	D	E	F	G
1	Jane
2	March
3		January		February		March
4		Sales	Returns	Sales	Returns	Sales	Returns
5	John	1	2	3	4	5	6
6	James	7	8	9	10	11	12
7	Jane	13	14	15	16	17	18
8
9	Sales	17
10	Returns	18
Sheet5

Cell Formulas
Range	Formula
B9	B9	=INDEX($B$5:$G$7,MATCH(A1,$A$5:$A$7,0),MATCH(A2,$B$3:$G$3,0))
B10	B10	=INDEX($B$5:$G$7,MATCH(A1,$A$5:$A$7,0),1+MATCH(A2,$B$3:$G$3,0))

 

[c_cha]

Try this (you didn't say where you wanted the result(s)):

Book3 (version 1).xlsb
	A	B	C	D	E	F	G
1	Jane
2	March
3		January		February		March
4		Sales	Returns	Sales	Returns	Sales	Returns
5	John	1	2	3	4	5	6
6	James	7	8	9	10	11	12
7	Jane	13	14	15	16	17	18
8
9	Sales	17
10	Returns	18
Sheet5

Cell Formulas
Range	Formula
B9	B9	=INDEX($B$5:$G$7,MATCH(A1,$A$5:$A$7,0),MATCH(A2,$B$3:$G$3,0))
B10	B10	=INDEX($B$5:$G$7,MATCH(A1,$A$5:$A$7,0),1+MATCH(A2,$B$3:$G$3,0))

You are a master! Thank you so much!