Auto-update cells based on a cell drop-down list and a table

Hi all,

I have what I hope is a quick question that I could really use help on. I have a drop down menu in cell G1 that allows for users to select the below deductible amounts (1,000, 2,000, 3,000, etc). In column D (Table) the user can manually enter one of the three table numbers shown below (1, 2 or 3). In column E, I have the below discount factors (shown below under the table numbers - currently being entered manually). Could someone please show me how to get cells column E to auto update, based on the deductible amount that is selected from the drop-down menu and the table number that is entered in column D? So for example, if the 1,000 is selected from the drop down menu and table 1 is entered in one of the cells in column D, then return value 0.043 in column E. Another example, if 5,000 is selected from the drop-down menu and table 2 is entered in one of the cells in column D, then return value .109 in column E.

Could this be done using a VLOOKUP or an IF Statement, or both? Any help would be greatly appreciated. Thank you.

Deductible
Amount Table 1 Table 2 Table 3
1,000 0.043 0.035 0.028
2,000 0.072 0.059 0.049
3,000 0.094 0.079 0.065
4,000 0.114 0.095 0.079
5,000 0.131 0.109 0.091
10,000 0.198 0.165 0.137
15,000 0.246 0.206 0.172
20,000 0.283 0.238 0.201
25,000 0.313 0.265 0.225
50,000 0.415 0.361 0.313
75,000 0.476 0.422 0.375
100,000 0.516 0.467 0.424

Your references are a bit confusing, but I think this is what you want...

	A	B	C	D	E	F	G
1	Amount	Table 1	Table 2	Table 3		Table 1	1000
2	1,000	0.043	0.035	0.028		0.043
3	2,000	0.072	0.059	0.049
4	3,000	0.094	0.079	0.065
5	4,000	0.114	0.095	0.079
6	5,000	0.131	0.109	0.091
7	10,000	0.198	0.165	0.137
8	15,000	0.246	0.206	0.172
9	20,000	0.283	0.238	0.201
10	25,000	0.313	0.265	0.225
11	50,000	0.415	0.361	0.313
12	75,000	0.476	0.422	0.375
13	100,000	0.516	0.467	0.424

F2=INDEX($B$2:$D$13,MATCH($G$1,$A$2:$A$13,0),MATCH($F$1,$B$1:$D$1,0))

For future reference, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

Hard to say what didnt work for you (cant see what you did), but based on your new sample...
=INDEX($J$5:$L$16,MATCH($B$2,$I$5:$I$16,0),MATCH($D6,$J$4:$L$4,0))
copied down

Happy to help

If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)