Lookup, Index and match problem with multiple criteria

[buster01]

Please Help.. I am trying to get a formula that will return the wt. per lf of size of bar in F3 from the table B30:J41 and will also return the length of lap required in F5 from the table B30:J41. I have tried several different formula's but nothing has worked. I have even tried breaking it down over several cells with vlookup and match but I still can't figure it out.

Excel2010 (Windows) 64 bit

A​	B​	C​	D​	E​	F​	G​	H​	I​	J​
Rows​
1​
2​				Size of Bottom Bar 1st Matt​	6​	#​
3​				Wt. Per Lf of Size of Bottom Bar 1st Matt​	?​	LBS.​
4​				Lapping Factor Bottom Bar 1st Matt​	40d​	LF​
5​				Length of Lap Required For Bottom Bar 1st Matt​	?​	LF​
6​
7​				Size of Top Bar 1st Matt​	4​	#​
8​				Wt. Per Lf of Size of Top Bar 1st Matt​	?​	LBS.​
9​				Lapping Factor Top Bar 1st Matt​	30d​	LF​
10​				Length of Lap Required For Top Bar 1st Matt​	?​	LF​
11​
12​									​
13​									​
14​	Bar Size​	Bar Diameter in (mm)​	Bar Diameter in (inches)​	Lbs. Per Lf.​	24d​	30d​	40d​	50d​	60d​
15​	3​	9.525​	0.375​	0.376​	0.75​	0.94​	1.25​	1.56​	1.88​
16​	4​	12.700​	0.500​	0.668​	1.00​	1.25​	1.67​	2.08​	2.50​
17​	5​	15.875​	0.625​	1.043​	1.25​	1.56​	2.08​	2.60​	3.13​
18​	6​	19.050​	0.750​	1.502​	1.50​	1.88​	2.50​	3.13​	3.75​
19​	7​	22.225​	0.875​	2.044​	1.75​	2.19​	2.92​	3.65​	4.38​
20​	8​	25.400​	1.000​	2.670​	2.00​	2.50​	3.33​	4.17​	5.00​
21​	9​	28.651​	1.128​	3.400​	2.26​	2.82​	3.76​	4.70​	5.64​
22​	10​	32.258​	1.270​	4.303​	2.54​	3.18​	4.23​	5.29​	6.35​
23​	11​	35.814​	1.410​	5.313​	2.82​	3.53​	4.70​	5.88​	7.05​
24​	14​	43.002​	1.693​	7.650​	N/A​	N/A​	N/A​	N/A​	N/A​
25​	16​	57.328​	2.257​	13.600​	N/A​	N/A​	N/A​	N/A​	N/A​
​
​				Example
2​				Size of Bottom Bar 1st Matt​	6​	#​
3​				Wt. Per Lf of Size of Bottom Bar 1st Matt​	1.502​	LBS.​
4​				Lapping Factor Bottom Bar 1st Matt​	40d​	LF​
5​				Length of Lap Required For Bottom Bar 1st Matt​	2.50​	LF​

<tbody> </tbody>

 

[Chrisdontm]

In Cell: F3
=SUMIFS($F$31:$F$34,$E$31:$E$34,$E3,$F$30:$F$33,$F2)

&

In Cell: F5
=SUMIFS($F$33:$F$36,$E$33:$E$36,$E5,$F$30:$F$33,$F2)

 

[buster01]

Chrisdontm, I am sorry I didn't explain myself correctly with the description or the example. As I mentioned this is my first time to post a question. Maybe this will help.
I am trying to get a formula that will return the wt. per lf based on the size of bar in C14 from the table EF8:EN18, and will also return the length of lap required in C18 from the same table. I need the same thing for C22 & C25. I am sorry for the incomplete information. Maybe this will help.
Thanks Again,


A B C D

ROW​
11​	Total Sf. Of Slab	0.00​	Sq Ft.​
12​	Length of Bar Used		LF​
13​	Spacing OC Bottom Bar 1st Matt		LF​
14​	Size of Bottom Bar 1st Matt	4​	#​
15​	Wt. Per Lf of Size of Bottom Bar 1st Matt	?​	LBS.​
16​	Rebar Inset from Edge of Slab Long Ways Bottom Bar 1st Matt		In​
17​	Lapping Factor Bottom Bar 1st Matt	40d​	LF​
18​	Length of Lap Required For Bottom Bar 1st Matt	?​	LF​
19​	Length of Bar Used Top Rows		LF​
20​	Spacing OC Top Bar 1st Matt		LF​
21​	Size of Top Bar 1st Matt	5​	#​
22​	Wt. Per Lf of Size of Top Bar 1st Matt	?​	LBS.​
23​	Rebar Inset from Edge of Slab Width Ways Top Bar 1st Matt		In​
24​	Lapping Factor Top Bar 1st Matt	50d​	LF​
25​	Length of Lap Required For Top Bar 1st Matt	?​	LF​

<tbody> </tbody>

THIS IS MY TABLE ​

EF EG EH EI EJ EK EL EM EN

Row ​	Bar Size​	Bar Diameter in (mm)​	Bar Diameter in (inches)​	Lbs. Per Lf.​	24d​	30d​	40d​	50d​	60d​
8​	3​	9.525​	0.375​	0.376​	0.75​	0.94​	1.25​	1.56​	1.88​
9​	4​	12.700​	0.500​	0.668​	1.00​	1.25​	1.67​	2.08​	2.50​
10​	5​	15.875​	0.625​	1.043​	1.25​	1.56​	2.08​	2.60​	3.13​
11​	6​	19.050​	0.750​	1.502​	1.50​	1.88​	2.50​	3.13​	3.75​
12​	7​	22.225​	0.875​	2.044​	1.75​	2.19​	2.92​	3.65​	4.38​
13​	8​	25.400​	1.000​	2.670​	2.00​	2.50​	3.33​	4.17​	5.00​
14​	9​	28.651​	1.128​	3.400​	2.26​	2.82​	3.76​	4.70​	5.64​
15​	10​	32.258​	1.270​	4.303​	2.54​	3.18​	4.23​	5.29​	6.35​
16​	11​	35.814​	1.410​	5.313​	2.82​	3.53​	4.70​	5.88​	7.05​
17​	14​	43.002​	1.693​	7.650​	N/A​	N/A​	N/A​	N/A​	N/A​
18​	16​	57.328​	2.257​	13.600​	N/A​	N/A​	N/A​	N/A​	N/A​

<tbody> </tbody>

 

[buster01]

The column #'s didn't post correctly, I apologize, but they are correct as far as the column let and in the order they should be.

 

[Chrisdontm]

Ok then try this in cell: C15

=INDEX($EF$7:$EN$18,MATCH(C14,$EF$7:$EF$18,0),MATCH(D15&"*",$EF$7:$EN$7,0))

Then try this in cell: C18

=INDEX($EF$7:$EN$18,MATCH(C14,$EF$7:$EF$18,0),MATCH(C17,$EF$7:$EN$7,0))

After that, copy cell: C15 and paste it into Cell: C22

After that, copy cell: C18 and paste it into Cell: C25

 

[buster01]

Chrisdontm, That worked...... thank you so much, I really appreciate it.
have a great blessed day...