vlookup with several variables in rows and columns

[baindes]

I have a spreadsheet that I am doing a paste link from the data source, the sheet you see below nearly mirrors the data source. So instead of manually copying the data each time I refresh it, I was wondering how to do a lookup off of column A and cell B5 for example. So I would want the lookup to say: Lookup in column A, Total US- Food for "Spearment" in row 5...etc. Thank you~

Excel Workbook
	A	B	C	D	E	F
5		SPEARMINT	WINTERBLUE	SWEET PEPPERMINT	FOREVER FRUIT	SWEET CINNAMON
6	TOTAL US - FOOD	4.4%	2.3%	3.0%	32.3%	15.9%
7	TOTAL US - FDMX	2.8%	1.4%	1.7%	42.7%	27.0%
8	TOTAL US - FDMXC	1.6%	0.9%	1.0%	25.6%	16.2%
9	TOTAL US - DRUG	0.1%	0.0%	0.1%	24.1%	2.0%
10	TOTAL US - CONV	0.0%	0.0%	0.0%	0.0%	0.0%
11	RMA - Albertsons LLC Corporate	80.6%	0.0%	0.0%	0.0%	0.0%
12	RMA - Albertsons LLC - ABS Dallas	83.2%	0.0%	0.0%	0.0%	0.0%
13	RMA - Albertsons LLC - ABS Florida	73.2%	0.0%	0.0%	0.0%	0.0%
14	RMA - Albertsons LLC - ABS Rocky Mountain	88.7%	0.0%	0.0%	0.0%	0.0%
15	RMA - Albertsons LLC - ABS Southwest	82.2%	0.0%	0.0%	0.0%	0.0%
16	RMA - BI-LO Corporate	4.5%	0.0%	0.0%	95.8%	2.7%
17	RMA - Bashas Corporate	0.0%	0.0%	0.0%	0.0%	0.0%
ACV WTD DIST

Excel 2007

 

[Dryver14]

Try inserting a drop down out of the way

say G2 has a drop down of companies, H2 has a drop down of ingredients.

Formula in G3

=INDEX(B6:F17,MATCH(G2,A6:A17,0),MATCH(H2,B5:F5,0))