Index or Match??

[wyeah]

Excel 2007, Windows XP...
I need a formula in cell Q7 that will return the value in the table, A2:K19, that match the intersection of the values in M7 and N7. Ex: M7=1211502, N7= K06 - MES_TargetRate, I need to return 46. I have a vLookup in column P but I do not want to change the row # every time the column N changes.

Thanks

Excel Workbook
	A	F	G	H	I	J	K	L	M	N	O	P	Q
2	Code1	K01 - MES_TargetRate	K02 - MES_TargetRate	K03 - MES_TargetRate	K04 - MES_TargetRate	K05 - MES_TargetRate	K06 - MES_TargetRate	*	*	*	*	*	*
3	1033701	*	32	18	*	*	*	*	product_code	characteristic_name	characteristic_value	RFS	*
4	1104501	35	35	35	25	*	*	*	1062700	K06 - MES_TargetRate	* * * * * * * * * * * * * * * * * 49	#N/A	*
5	1168700	*	*	18	*	*	*	*	1211500	K06 - MES_TargetRate	* * * * * * * * * * * * * * * * * 30	#N/A	*
6	1168701	*	*	18	*	*	*	*	1211501	K06 - MES_TargetRate	* * * * * * * * * * * * * * * * * 45	#N/A	*
7	1168901	*	*	20	*	*	*	*	1211502	K06 - MES_TargetRate	* * * * * * * * * * * * * * * * * 46	* * * 46	*
8	1169001	*	*	16	*	*	*	*	1211600	K06 - MES_TargetRate	* * * * * * * * * * * * * * * * * 40	#N/A	*
9	1169101	*	*	20	*	*	*	*	1211601	K06 - MES_TargetRate	* * * * * * * * * * * * * * * * * 40	#N/A	*
10	1169201	*	*	21	*	*	*	*	1211602	K06 - MES_TargetRate	* * * * * * * * * * * * * * * * * 42	* * * 42	*
11	1211000	*	34	18	*	*	*	*	1211700	K06 - MES_TargetRate	* * * * * * * * * * * * * * * * * 46	#N/A	*
12	1211001	*	34	18	*	*	*	*	1211800	K06 - MES_TargetRate	* * * * * * * * * * * * * * * * * 40	#N/A	*
13	1211101	*	*	26	38	*	*	*	1211801	K06 - MES_TargetRate	* * * * * * * * * * * * * * * * * 40	#N/A	*
14	1211200	*	*	*	*	25	*	*	1211802	K06 - MES_TargetRate	* * * * * * * * * * * * * * * * * 40	* * * 40	*
15	1211201	*	*	*	*	25	*	*	1602800	K06 - MES_TargetRate	* * * * * * * * * * * * * * * * * 38	#N/A	*
16	1211300	*	34	18	*	*	*	*	1602810	K06 - MES_TargetRate	* * * * * * * * * * * * * * * * * 38	#N/A	*
17	1211400	*	*	26	30	*	*	*	1602900	K06 - MES_TargetRate	* * * * * * * * * * * * * * * * * 26	#N/A	*
18	1211502	*	*	32	29	49	46	*	1603600	K06 - MES_TargetRate	* * * * * * * * * * * * * * * * * 40	#N/A	*
19	1211602	*	*	32	*	49	42	*	1603601	K06 - MES_TargetRate	* * * * * * * * * * * * * * * * * 45	* * * 42	45
Sheet1

 

[Jonmo1]

Actually, you need both Index AND Match...

Try this in O4 and filled down.

=IDNEX($A$2:$K$19,MATCH($M4,$A$2:$A$19,0),MATCH($N4,$A$2:$K$2,0))

 

[dbrown]

You could also use a VLOOKUP formula and use a MATCH function to automate the col_index_num argument of the VLOOKUP function

try this in O4 and fill down

=VLOOKUP(M4,$A$2:$K$19,MATCH($N4,$A$2:$K$2,0),0)

 

[wyeah]

Thanks to both of you for the quick response. Either one will work.