Changing Cell References in a table

[BuffaloGuy]

I have two drop down boxes, one in A1 with numbers 1, 2, 3, 4, 5 and one in B1 with 10, 20, 30, 40, 50 in it.
I have a table with headers starting in A2:F7. Cells A3 through A7 say 1-5 respectively and cells B2 through F2 say 10 through 50 respectively.

In Cell C1, what formula do I need to type that references the values that change in cells A1 and B1. So as I change A1 or B1, C1 displays the intersection of the new values?

I feel like it’s a version of index and match and I can’t figure it out.

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Is this what you want?

25 01 04.xlsm
	A	B	C	D	E	F
1	3	20	H
2		10	20	30	40	50
3	1	A	F	K	P	U
4	2	B	G	L	Q	V
5	3	C	H	M	R	W
6	4	D	I	N	S	X
7	5	E	J	O	T	Y
BuffaloGuy

Cell Formulas
Range	Formula
C1	C1	=INDEX(B3:F7,MATCH(A1,A3:A7,0),MATCH(B1,B2:F2,0))

Cells with Data Validation
Cell	Allow	Criteria
A1	List	1,2,3,4,5
B1	List	10,20,30,40,50