Lookup, Index and match problem with multiple criteria

B

buster01

New Member
Joined
Jan 10, 2014
Messages
13
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
[TABLE="width: 469"]
<tbody>[TR]
[TD="width: 47, bgcolor: transparent"]
A​
[/TD]
[TD="width: 55, bgcolor: transparent"]
B​
[/TD]
[TD="width: 82, bgcolor: transparent"]
C​
[/TD]
[TD="width: 73, bgcolor: transparent"]
D​
[/TD]
[TD="width: 236, bgcolor: transparent"]
E​
[/TD]
[TD="width: 56, bgcolor: transparent"]
F​
[/TD]
[TD="width: 54, bgcolor: transparent"]
G​
[/TD]
[TD="width: 63, bgcolor: transparent"]
H​
[/TD]
[TD="width: 59, bgcolor: transparent"]
I​
[/TD]
[TD="width: 58, bgcolor: transparent"]
J​
[/TD]
[/TR]
[TR]
[TD="width: 47, bgcolor: transparent"]
Rows​
[/TD]
[TD="width: 55, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 73, bgcolor: transparent"][/TD]
[TD="width: 236, bgcolor: transparent"][/TD]
[TD="width: 56, bgcolor: transparent"][/TD]
[TD="width: 54, bgcolor: transparent"][/TD]
[TD="width: 63, bgcolor: transparent"][/TD]
[TD="width: 59, bgcolor: transparent"][/TD]
[TD="width: 58, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 47, bgcolor: transparent"]
1​
[/TD]
[TD="width: 55, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 73, bgcolor: transparent"][/TD]
[TD="width: 236, bgcolor: transparent"][/TD]
[TD="width: 56, bgcolor: transparent"][/TD]
[TD="width: 54, bgcolor: transparent"][/TD]
[TD="width: 63, bgcolor: transparent"][/TD]
[TD="width: 59, bgcolor: transparent"][/TD]
[TD="width: 58, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 47, bgcolor: transparent"]
2​
[/TD]
[TD="width: 55, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"]
[/TD]
[TD="width: 73, bgcolor: transparent"]
[/TD]
[TD="width: 236, bgcolor: transparent"]
Size of Bottom Bar 1st Matt​
[/TD]
[TD="width: 56, bgcolor: transparent"]
6​
[/TD]
[TD="width: 54, bgcolor: transparent"]
#​
[/TD]
[TD="width: 63, bgcolor: transparent"][/TD]
[TD="width: 59, bgcolor: transparent"][/TD]
[TD="width: 58, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 47, bgcolor: transparent"]
3​
[/TD]
[TD="width: 55, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"]
[/TD]
[TD="width: 73, bgcolor: transparent"]
[/TD]
[TD="width: 236, bgcolor: transparent"]
Wt. Per Lf of Size of Bottom Bar 1st Matt​
[/TD]
[TD="width: 56, bgcolor: transparent"]
?​
[/TD]
[TD="width: 54, bgcolor: transparent"]
LBS.​
[/TD]
[TD="width: 63, bgcolor: transparent"][/TD]
[TD="width: 59, bgcolor: transparent"][/TD]
[TD="width: 58, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 47, bgcolor: transparent"]
4​
[/TD]
[TD="width: 55, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"]
[/TD]
[TD="width: 73, bgcolor: transparent"]
[/TD]
[TD="width: 236, bgcolor: transparent"]
Lapping Factor Bottom Bar 1st Matt​
[/TD]
[TD="width: 56, bgcolor: transparent"]
40d​
[/TD]
[TD="width: 54, bgcolor: transparent"]
LF​
[/TD]
[TD="width: 63, bgcolor: transparent"][/TD]
[TD="width: 59, bgcolor: transparent"][/TD]
[TD="width: 58, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 47, bgcolor: transparent"]
5​
[/TD]
[TD="width: 55, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"]
[/TD]
[TD="width: 73, bgcolor: transparent"]
[/TD]
[TD="width: 236, bgcolor: transparent"]
Length of Lap Required For Bottom Bar 1st Matt​
[/TD]
[TD="width: 56, bgcolor: transparent"]
?​
[/TD]
[TD="width: 54, bgcolor: transparent"]
LF​
[/TD]
[TD="width: 63, bgcolor: transparent"][/TD]
[TD="width: 59, bgcolor: transparent"][/TD]
[TD="width: 58, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 47, bgcolor: transparent"]
6​
[/TD]
[TD="width: 55, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 73, bgcolor: transparent"][/TD]
[TD="width: 236, bgcolor: transparent"][/TD]
[TD="width: 56, bgcolor: transparent"][/TD]
[TD="width: 54, bgcolor: transparent"][/TD]
[TD="width: 63, bgcolor: transparent"][/TD]
[TD="width: 59, bgcolor: transparent"][/TD]
[TD="width: 58, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 47, bgcolor: transparent"]
7​
[/TD]
[TD="width: 55, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"]
[/TD]
[TD="width: 73, bgcolor: transparent"]
[/TD]
[TD="width: 236, bgcolor: transparent"]
Size of Top Bar 1st Matt​
[/TD]
[TD="width: 56, bgcolor: transparent"]
4​
[/TD]
[TD="width: 54, bgcolor: transparent"]
#​
[/TD]
[TD="width: 63, bgcolor: transparent"][/TD]
[TD="width: 59, bgcolor: transparent"][/TD]
[TD="width: 58, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 47, bgcolor: transparent"]
8​
[/TD]
[TD="width: 55, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"]
[/TD]
[TD="width: 73, bgcolor: transparent"]
[/TD]
[TD="width: 236, bgcolor: transparent"]
Wt. Per Lf of Size of Top Bar 1st Matt​
[/TD]
[TD="width: 56, bgcolor: transparent"]
?​
[/TD]
[TD="width: 54, bgcolor: transparent"]
LBS.​
[/TD]
[TD="width: 63, bgcolor: transparent"][/TD]
[TD="width: 59, bgcolor: transparent"][/TD]
[TD="width: 58, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 47, bgcolor: transparent"]
9​
[/TD]
[TD="width: 55, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"]
[/TD]
[TD="width: 73, bgcolor: transparent"]
[/TD]
[TD="width: 236, bgcolor: transparent"]
Lapping Factor Top Bar 1st Matt​
[/TD]
[TD="width: 56, bgcolor: transparent"]
30d​
[/TD]
[TD="width: 54, bgcolor: transparent"]
LF​
[/TD]
[TD="width: 63, bgcolor: transparent"][/TD]
[TD="width: 59, bgcolor: transparent"][/TD]
[TD="width: 58, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 47, bgcolor: transparent"]
10​
[/TD]
[TD="width: 55, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"]
[/TD]
[TD="width: 73, bgcolor: transparent"]
[/TD]
[TD="width: 236, bgcolor: transparent"]
Length of Lap Required For Top Bar 1st Matt​
[/TD]
[TD="width: 56, bgcolor: transparent"]
?​
[/TD]
[TD="width: 54, bgcolor: transparent"]
LF​
[/TD]
[TD="width: 63, bgcolor: transparent"][/TD]
[TD="width: 59, bgcolor: transparent"][/TD]
[TD="width: 58, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 47, bgcolor: transparent"]
11​
[/TD]
[TD="width: 55, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 73, bgcolor: transparent"][/TD]
[TD="width: 236, bgcolor: transparent"][/TD]
[TD="width: 56, bgcolor: transparent"][/TD]
[TD="width: 54, bgcolor: transparent"][/TD]
[TD="width: 63, bgcolor: transparent"][/TD]
[TD="width: 59, bgcolor: transparent"][/TD]
[TD="width: 58, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 47, bgcolor: transparent"]
12​
[/TD]
[TD="width: 55, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 73, bgcolor: transparent"][/TD]
[TD="width: 236, bgcolor: transparent"][/TD]
[TD="width: 56, bgcolor: transparent"][/TD]
[TD="width: 54, bgcolor: transparent"][/TD]
[TD="width: 63, bgcolor: transparent"][/TD]
[TD="width: 59, bgcolor: transparent"][/TD]
[TD="width: 58, bgcolor: transparent"]
​
[/TD]
[/TR]
[TR]
[TD="width: 47, bgcolor: transparent"]
13​
[/TD]
[TD="width: 55, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 73, bgcolor: transparent"][/TD]
[TD="width: 236, bgcolor: transparent"][/TD]
[TD="width: 56, bgcolor: transparent"][/TD]
[TD="width: 54, bgcolor: transparent"][/TD]
[TD="width: 63, bgcolor: transparent"][/TD]
[TD="width: 59, bgcolor: transparent"][/TD]
[TD="width: 58, bgcolor: transparent"]
​
[/TD]
[/TR]
[TR]
[TD="width: 47, bgcolor: transparent"]
14​
[/TD]
[TD="width: 55, bgcolor: transparent"]
Bar Size​
[/TD]
[TD="width: 82, bgcolor: transparent"]
Bar Diameter in (mm)​
[/TD]
[TD="width: 73, bgcolor: transparent"]
Bar Diameter in (inches)​
[/TD]
[TD="width: 236, bgcolor: transparent"]
Lbs. Per Lf.​
[/TD]
[TD="width: 56, bgcolor: transparent"]
24d​
[/TD]
[TD="width: 54, bgcolor: transparent"]
30d​
[/TD]
[TD="width: 63, bgcolor: transparent"]
40d​
[/TD]
[TD="width: 59, bgcolor: transparent"]
50d​
[/TD]
[TD="width: 58, bgcolor: transparent"]
60d​
[/TD]
[/TR]
[TR]
[TD="width: 47, bgcolor: transparent"]
15​
[/TD]
[TD="width: 55, bgcolor: transparent"]
3​
[/TD]
[TD="width: 82, bgcolor: transparent"]
9.525​
[/TD]
[TD="width: 73, bgcolor: transparent"]
0.375​
[/TD]
[TD="width: 236, bgcolor: transparent"]
0.376​
[/TD]
[TD="width: 56, bgcolor: transparent"]
0.75​
[/TD]
[TD="width: 54, bgcolor: transparent"]
0.94​
[/TD]
[TD="width: 63, bgcolor: transparent"]
1.25​
[/TD]
[TD="width: 59, bgcolor: transparent"]
1.56​
[/TD]
[TD="width: 58, bgcolor: transparent"]
1.88​
[/TD]
[/TR]
[TR]
[TD="width: 47, bgcolor: transparent"]
16​
[/TD]
[TD="width: 55, bgcolor: transparent"]
4​
[/TD]
[TD="width: 82, bgcolor: transparent"]
12.700​
[/TD]
[TD="width: 73, bgcolor: transparent"]
0.500​
[/TD]
[TD="width: 236, bgcolor: transparent"]
0.668​
[/TD]
[TD="width: 56, bgcolor: transparent"]
1.00​
[/TD]
[TD="width: 54, bgcolor: transparent"]
1.25​
[/TD]
[TD="width: 63, bgcolor: transparent"]
1.67​
[/TD]
[TD="width: 59, bgcolor: transparent"]
2.08​
[/TD]
[TD="width: 58, bgcolor: transparent"]
2.50​
[/TD]
[/TR]
[TR]
[TD="width: 47, bgcolor: transparent"]
17​
[/TD]
[TD="width: 55, bgcolor: transparent"]
5​
[/TD]
[TD="width: 82, bgcolor: transparent"]
15.875​
[/TD]
[TD="width: 73, bgcolor: transparent"]
0.625​
[/TD]
[TD="width: 236, bgcolor: transparent"]
1.043​
[/TD]
[TD="width: 56, bgcolor: transparent"]
1.25​
[/TD]
[TD="width: 54, bgcolor: transparent"]
1.56​
[/TD]
[TD="width: 63, bgcolor: transparent"]
2.08​
[/TD]
[TD="width: 59, bgcolor: transparent"]
2.60​
[/TD]
[TD="width: 58, bgcolor: transparent"]
3.13​
[/TD]
[/TR]
[TR]
[TD="width: 47, bgcolor: transparent"]
18​
[/TD]
[TD="width: 55, bgcolor: transparent"]
6​
[/TD]
[TD="width: 82, bgcolor: transparent"]
19.050​
[/TD]
[TD="width: 73, bgcolor: transparent"]
0.750​
[/TD]
[TD="width: 236, bgcolor: transparent"]
1.502​
[/TD]
[TD="width: 56, bgcolor: transparent"]
1.50​
[/TD]
[TD="width: 54, bgcolor: transparent"]
1.88​
[/TD]
[TD="width: 63, bgcolor: transparent"]
2.50​
[/TD]
[TD="width: 59, bgcolor: transparent"]
3.13​
[/TD]
[TD="width: 58, bgcolor: transparent"]
3.75​
[/TD]
[/TR]
[TR]
[TD="width: 47, bgcolor: transparent"]
19​
[/TD]
[TD="width: 55, bgcolor: transparent"]
7​
[/TD]
[TD="width: 82, bgcolor: transparent"]
22.225​
[/TD]
[TD="width: 73, bgcolor: transparent"]
0.875​
[/TD]
[TD="width: 236, bgcolor: transparent"]
2.044​
[/TD]
[TD="width: 56, bgcolor: transparent"]
1.75​
[/TD]
[TD="width: 54, bgcolor: transparent"]
2.19​
[/TD]
[TD="width: 63, bgcolor: transparent"]
2.92​
[/TD]
[TD="width: 59, bgcolor: transparent"]
3.65​
[/TD]
[TD="width: 58, bgcolor: transparent"]
4.38​
[/TD]
[/TR]
[TR]
[TD="width: 47, bgcolor: transparent"]
20​
[/TD]
[TD="width: 55, bgcolor: transparent"]
8​
[/TD]
[TD="width: 82, bgcolor: transparent"]
25.400​
[/TD]
[TD="width: 73, bgcolor: transparent"]
1.000​
[/TD]
[TD="width: 236, bgcolor: transparent"]
2.670​
[/TD]
[TD="width: 56, bgcolor: transparent"]
2.00​
[/TD]
[TD="width: 54, bgcolor: transparent"]
2.50​
[/TD]
[TD="width: 63, bgcolor: transparent"]
3.33​
[/TD]
[TD="width: 59, bgcolor: transparent"]
4.17​
[/TD]
[TD="width: 58, bgcolor: transparent"]
5.00​
[/TD]
[/TR]
[TR]
[TD="width: 47, bgcolor: transparent"]
21​
[/TD]
[TD="width: 55, bgcolor: transparent"]
9​
[/TD]
[TD="width: 82, bgcolor: transparent"]
28.651​
[/TD]
[TD="width: 73, bgcolor: transparent"]
1.128​
[/TD]
[TD="width: 236, bgcolor: transparent"]
3.400​
[/TD]
[TD="width: 56, bgcolor: transparent"]
2.26​
[/TD]
[TD="width: 54, bgcolor: transparent"]
2.82​
[/TD]
[TD="width: 63, bgcolor: transparent"]
3.76​
[/TD]
[TD="width: 59, bgcolor: transparent"]
4.70​
[/TD]
[TD="width: 58, bgcolor: transparent"]
5.64​
[/TD]
[/TR]
[TR]
[TD="width: 47, bgcolor: transparent"]
22​
[/TD]
[TD="width: 55, bgcolor: transparent"]
10​
[/TD]
[TD="width: 82, bgcolor: transparent"]
32.258​
[/TD]
[TD="width: 73, bgcolor: transparent"]
1.270​
[/TD]
[TD="width: 236, bgcolor: transparent"]
4.303​
[/TD]
[TD="width: 56, bgcolor: transparent"]
2.54​
[/TD]
[TD="width: 54, bgcolor: transparent"]
3.18​
[/TD]
[TD="width: 63, bgcolor: transparent"]
4.23​
[/TD]
[TD="width: 59, bgcolor: transparent"]
5.29​
[/TD]
[TD="width: 58, bgcolor: transparent"]
6.35​
[/TD]
[/TR]
[TR]
[TD="width: 47, bgcolor: transparent"]
23​
[/TD]
[TD="width: 55, bgcolor: transparent"]
11​
[/TD]
[TD="width: 82, bgcolor: transparent"]
35.814​
[/TD]
[TD="width: 73, bgcolor: transparent"]
1.410​
[/TD]
[TD="width: 236, bgcolor: transparent"]
5.313​
[/TD]
[TD="width: 56, bgcolor: transparent"]
2.82​
[/TD]
[TD="width: 54, bgcolor: transparent"]
3.53​
[/TD]
[TD="width: 63, bgcolor: transparent"]
4.70​
[/TD]
[TD="width: 59, bgcolor: transparent"]
5.88​
[/TD]
[TD="width: 58, bgcolor: transparent"]
7.05​
[/TD]
[/TR]
[TR]
[TD="width: 47, bgcolor: transparent"]
24​
[/TD]
[TD="width: 55, bgcolor: transparent"]
14​
[/TD]
[TD="width: 82, bgcolor: transparent"]
43.002​
[/TD]
[TD="width: 73, bgcolor: transparent"]
1.693​
[/TD]
[TD="width: 236, bgcolor: transparent"]
7.650​
[/TD]
[TD="width: 56, bgcolor: transparent"]
N/A​
[/TD]
[TD="width: 54, bgcolor: transparent"]
N/A​
[/TD]
[TD="width: 63, bgcolor: transparent"]
N/A​
[/TD]
[TD="width: 59, bgcolor: transparent"]
N/A​
[/TD]
[TD="width: 58, bgcolor: transparent"]
N/A​
[/TD]
[/TR]
[TR]
[TD="width: 47, bgcolor: transparent"]
25​
[/TD]
[TD="width: 55, bgcolor: transparent"]
16​
[/TD]
[TD="width: 82, bgcolor: transparent"]
57.328​
[/TD]
[TD="width: 73, bgcolor: transparent"]
2.257​
[/TD]
[TD="width: 236, bgcolor: transparent"]
13.600​
[/TD]
[TD="width: 56, bgcolor: transparent"]
N/A​
[/TD]
[TD="width: 54, bgcolor: transparent"]
N/A​
[/TD]
[TD="width: 63, bgcolor: transparent"]
N/A​
[/TD]
[TD="width: 59, bgcolor: transparent"]
N/A​
[/TD]
[TD="width: 58, bgcolor: transparent"]
N/A​
[/TD]
[/TR]
[TR]
[TD="width: 47, bgcolor: transparent"]
​
[/TD]
[TD="width: 55, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 73, bgcolor: transparent"][/TD]
[TD="width: 236, bgcolor: transparent"][/TD]
[TD="width: 56, bgcolor: transparent"][/TD]
[TD="width: 54, bgcolor: transparent"][/TD]
[TD="width: 63, bgcolor: transparent"][/TD]
[TD="width: 59, bgcolor: transparent"][/TD]
[TD="width: 58, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 47, bgcolor: transparent"]
​
[/TD]
[TD="width: 55, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 73, bgcolor: transparent"][/TD]
[TD="width: 236, bgcolor: transparent"] Example
[/TD]
[TD="width: 56, bgcolor: transparent"][/TD]
[TD="width: 54, bgcolor: transparent"][/TD]
[TD="width: 63, bgcolor: transparent"][/TD]
[TD="width: 59, bgcolor: transparent"][/TD]
[TD="width: 58, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 47, bgcolor: transparent"]
2​
[/TD]
[TD="width: 55, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 73, bgcolor: transparent"][/TD]
[TD="width: 236, bgcolor: transparent"]
Size of Bottom Bar 1st Matt​
[/TD]
[TD="width: 56, bgcolor: transparent"]
6​
[/TD]
[TD="width: 54, bgcolor: transparent"]
#​
[/TD]
[TD="width: 63, bgcolor: transparent"][/TD]
[TD="width: 59, bgcolor: transparent"][/TD]
[TD="width: 58, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 47, bgcolor: transparent"]
3​
[/TD]
[TD="width: 55, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 73, bgcolor: transparent"][/TD]
[TD="width: 236, bgcolor: transparent"]
Wt. Per Lf of Size of Bottom Bar 1st Matt​
[/TD]
[TD="width: 56"]
1.502​
[/TD]
[TD="width: 54, bgcolor: transparent"]
LBS.​
[/TD]
[TD="width: 63, bgcolor: transparent"][/TD]
[TD="width: 59, bgcolor: transparent"][/TD]
[TD="width: 58, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 47, bgcolor: transparent"]
4​
[/TD]
[TD="width: 55, bgcolor: transparent"][/TD]
[TD="width: 82, bgcolor: transparent"][/TD]
[TD="width: 73, bgcolor: transparent"][/TD]
[TD="width: 236, bgcolor: transparent"]
Lapping Factor Bottom Bar 1st Matt​
[/TD]
[TD="width: 56, bgcolor: transparent"]
40d​
[/TD]
[TD="width: 54, bgcolor: transparent"]
LF​
[/TD]
[TD="width: 63, bgcolor: transparent"][/TD]
[TD="width: 59, bgcolor: transparent"][/TD]
[TD="width: 58, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="width: 47, bgcolor: transparent"]
5​
[/TD]
[TD="width: 55, bgcolor: transparent"]
[/TD]
[TD="width: 82, bgcolor: transparent"]
[/TD]
[TD="width: 73, bgcolor: transparent"]
[/TD]
[TD="width: 236, bgcolor: transparent"]
Length of Lap Required For Bottom Bar 1st Matt​
[/TD]
[TD="width: 56"]
2.50​
[/TD]
[TD="width: 54, bgcolor: transparent"]
LF​
[/TD]
[TD="width: 63, bgcolor: transparent"]
[/TD]
[TD="width: 59, bgcolor: transparent"]
[/TD]
[TD="width: 58, bgcolor: transparent"]
[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
Sort by date Sort by votes
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)
 
Upvote 0
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



<tbody> [TD="width: 230, bgcolor: transparent"]
ROW​
[/TD]
[TD="width: 528, bgcolor: transparent"][/TD]
[TD="width: 100, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 230, bgcolor: transparent"]
11​
[/TD]
[TD="width: 528, bgcolor: transparent"] Total Sf. Of Slab [/TD]
[TD="width: 100, bgcolor: transparent"]
0.00​
[/TD]
[TD="width: 81, bgcolor: transparent"]
Sq Ft.​
[/TD]
[TD="width: 230, bgcolor: transparent"]
12​
[/TD]
[TD="width: 528, bgcolor: transparent"] Length of Bar Used [/TD]
[TD="width: 100, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"]
LF​
[/TD]
[TD="width: 230, bgcolor: transparent"]
13​
[/TD]
[TD="width: 528, bgcolor: transparent"] Spacing OC Bottom Bar 1st Matt [/TD]
[TD="width: 100, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"]
LF​
[/TD]
[TD="width: 230, bgcolor: transparent"]
14​
[/TD]
[TD="width: 528, bgcolor: transparent"] Size of Bottom Bar 1st Matt [/TD]
[TD="width: 100, bgcolor: transparent"]
4​
[/TD]
[TD="width: 81, bgcolor: transparent"]
#​
[/TD]
[TD="width: 230, bgcolor: transparent"]
15​
[/TD]
[TD="width: 528, bgcolor: transparent"] Wt. Per Lf of Size of Bottom Bar 1st Matt [/TD]
[TD="width: 100, bgcolor: transparent"]
?​
[/TD]
[TD="width: 81, bgcolor: transparent"]
LBS.​
[/TD]
[TD="width: 230, bgcolor: transparent"]
16​
[/TD]
[TD="width: 528, bgcolor: transparent"] Rebar Inset from Edge of Slab Long Ways Bottom Bar 1st Matt [/TD]
[TD="width: 100, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"]
In​
[/TD]
[TD="width: 230, bgcolor: transparent"]
17​
[/TD]
[TD="width: 528, bgcolor: transparent"] Lapping Factor Bottom Bar 1st Matt [/TD]
[TD="width: 100, bgcolor: transparent"]
40d​
[/TD]
[TD="width: 81, bgcolor: transparent"]
LF​
[/TD]
[TD="width: 230, bgcolor: transparent"]
18​
[/TD]
[TD="width: 528, bgcolor: transparent"] Length of Lap Required For Bottom Bar 1st Matt [/TD]
[TD="width: 100, bgcolor: transparent"]
?​
[/TD]
[TD="width: 81, bgcolor: transparent"]
LF​
[/TD]
[TD="width: 230, bgcolor: transparent"]
19​
[/TD]
[TD="width: 528, bgcolor: transparent"] Length of Bar Used Top Rows [/TD]
[TD="width: 100, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"]
LF​
[/TD]
[TD="width: 230, bgcolor: transparent"]
20​
[/TD]
[TD="width: 528, bgcolor: transparent"] Spacing OC Top Bar 1st Matt [/TD]
[TD="width: 100, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"]
LF​
[/TD]
[TD="width: 230, bgcolor: transparent"]
21​
[/TD]
[TD="width: 528, bgcolor: transparent"] Size of Top Bar 1st Matt [/TD]
[TD="width: 100, bgcolor: transparent"]
5​
[/TD]
[TD="width: 81, bgcolor: transparent"]
#​
[/TD]
[TD="width: 230, bgcolor: transparent"]
22​
[/TD]
[TD="width: 528, bgcolor: transparent"] Wt. Per Lf of Size of Top Bar 1st Matt [/TD]
[TD="width: 100, bgcolor: transparent"]
?​
[/TD]
[TD="width: 81, bgcolor: transparent"]
LBS.​
[/TD]
[TD="width: 230, bgcolor: transparent"]
23​
[/TD]
[TD="width: 528, bgcolor: transparent"] Rebar Inset from Edge of Slab Width Ways Top Bar 1st Matt [/TD]
[TD="width: 100, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"]
In​
[/TD]
[TD="width: 230, bgcolor: transparent"]
24​
[/TD]
[TD="width: 528, bgcolor: transparent"] Lapping Factor Top Bar 1st Matt [/TD]
[TD="width: 100, bgcolor: transparent"]
50d​
[/TD]
[TD="width: 81, bgcolor: transparent"]
LF​
[/TD]
[TD="width: 230, bgcolor: transparent"]
25​
[/TD]
[TD="width: 528, bgcolor: transparent"] Length of Lap Required For Top Bar 1st Matt [/TD]
[TD="width: 100, bgcolor: transparent"]
?​
[/TD]
[TD="width: 81, bgcolor: transparent"]
LF​
[/TD]
</tbody>





THIS IS MY TABLE ​


EF EG EH EI EJ EK EL EM EN



<tbody> [TD="width: 120, bgcolor: transparent"]
Row
​
[/TD]
[TD="width: 120, bgcolor: transparent"]
Bar Size​
[/TD]
[TD="width: 246, bgcolor: transparent"]
Bar Diameter in (mm)​
[/TD]
[TD="width: 276, bgcolor: transparent"]
Bar Diameter in (inches)​
[/TD]
[TD="width: 140, bgcolor: transparent"]
Lbs. Per Lf.​
[/TD]
[TD="width: 120, bgcolor: transparent"]
24d​
[/TD]
[TD="width: 120, bgcolor: transparent"]
30d​
[/TD]
[TD="width: 120, bgcolor: transparent"]
40d​
[/TD]
[TD="width: 120, bgcolor: transparent"]
50d​
[/TD]
[TD="width: 120, bgcolor: transparent"]
60d​
[/TD]
[TD="width: 120, bgcolor: transparent"]
8​
[/TD]
[TD="width: 120, bgcolor: transparent"]
3​
[/TD]
[TD="width: 246, bgcolor: transparent"]
9.525​
[/TD]
[TD="width: 276, bgcolor: transparent"]
0.375​
[/TD]
[TD="width: 140, bgcolor: transparent"]
0.376​
[/TD]
[TD="width: 120, bgcolor: transparent"]
0.75​
[/TD]
[TD="width: 120, bgcolor: transparent"]
0.94​
[/TD]
[TD="width: 120, bgcolor: transparent"]
1.25​
[/TD]
[TD="width: 120, bgcolor: transparent"]
1.56​
[/TD]
[TD="width: 120, bgcolor: transparent"]
1.88​
[/TD]
[TD="width: 120, bgcolor: transparent"]
9​
[/TD]
[TD="width: 120, bgcolor: transparent"]
4​
[/TD]
[TD="width: 246, bgcolor: transparent"]
12.700​
[/TD]
[TD="width: 276, bgcolor: transparent"]
0.500​
[/TD]
[TD="width: 140, bgcolor: transparent"]
0.668​
[/TD]
[TD="width: 120, bgcolor: transparent"]
1.00​
[/TD]
[TD="width: 120, bgcolor: transparent"]
1.25​
[/TD]
[TD="width: 120, bgcolor: transparent"]
1.67​
[/TD]
[TD="width: 120, bgcolor: transparent"]
2.08​
[/TD]
[TD="width: 120, bgcolor: transparent"]
2.50​
[/TD]
[TD="width: 120, bgcolor: transparent"]
10​
[/TD]
[TD="width: 120, bgcolor: transparent"]
5​
[/TD]
[TD="width: 246, bgcolor: transparent"]
15.875​
[/TD]
[TD="width: 276, bgcolor: transparent"]
0.625​
[/TD]
[TD="width: 140, bgcolor: transparent"]
1.043​
[/TD]
[TD="width: 120, bgcolor: transparent"]
1.25​
[/TD]
[TD="width: 120, bgcolor: transparent"]
1.56​
[/TD]
[TD="width: 120, bgcolor: transparent"]
2.08​
[/TD]
[TD="width: 120, bgcolor: transparent"]
2.60​
[/TD]
[TD="width: 120, bgcolor: transparent"]
3.13​
[/TD]
[TD="width: 120, bgcolor: transparent"]
11​
[/TD]
[TD="width: 120, bgcolor: transparent"]
6​
[/TD]
[TD="width: 246, bgcolor: transparent"]
19.050​
[/TD]
[TD="width: 276, bgcolor: transparent"]
0.750​
[/TD]
[TD="width: 140, bgcolor: transparent"]
1.502​
[/TD]
[TD="width: 120, bgcolor: transparent"]
1.50​
[/TD]
[TD="width: 120, bgcolor: transparent"]
1.88​
[/TD]
[TD="width: 120, bgcolor: transparent"]
2.50​
[/TD]
[TD="width: 120, bgcolor: transparent"]
3.13​
[/TD]
[TD="width: 120, bgcolor: transparent"]
3.75​
[/TD]
[TD="width: 120, bgcolor: transparent"]
12​
[/TD]
[TD="width: 120, bgcolor: transparent"]
7​
[/TD]
[TD="width: 246, bgcolor: transparent"]
22.225​
[/TD]
[TD="width: 276, bgcolor: transparent"]
0.875​
[/TD]
[TD="width: 140, bgcolor: transparent"]
2.044​
[/TD]
[TD="width: 120, bgcolor: transparent"]
1.75​
[/TD]
[TD="width: 120, bgcolor: transparent"]
2.19​
[/TD]
[TD="width: 120, bgcolor: transparent"]
2.92​
[/TD]
[TD="width: 120, bgcolor: transparent"]
3.65​
[/TD]
[TD="width: 120, bgcolor: transparent"]
4.38​
[/TD]
[TD="width: 120, bgcolor: transparent"]
13​
[/TD]
[TD="width: 120, bgcolor: transparent"]
8​
[/TD]
[TD="width: 246, bgcolor: transparent"]
25.400​
[/TD]
[TD="width: 276, bgcolor: transparent"]
1.000​
[/TD]
[TD="width: 140, bgcolor: transparent"]
2.670​
[/TD]
[TD="width: 120, bgcolor: transparent"]
2.00​
[/TD]
[TD="width: 120, bgcolor: transparent"]
2.50​
[/TD]
[TD="width: 120, bgcolor: transparent"]
3.33​
[/TD]
[TD="width: 120, bgcolor: transparent"]
4.17​
[/TD]
[TD="width: 120, bgcolor: transparent"]
5.00​
[/TD]
[TD="width: 120, bgcolor: transparent"]
14​
[/TD]
[TD="width: 120, bgcolor: transparent"]
9​
[/TD]
[TD="width: 246, bgcolor: transparent"]
28.651​
[/TD]
[TD="width: 276, bgcolor: transparent"]
1.128​
[/TD]
[TD="width: 140, bgcolor: transparent"]
3.400​
[/TD]
[TD="width: 120, bgcolor: transparent"]
2.26​
[/TD]
[TD="width: 120, bgcolor: transparent"]
2.82​
[/TD]
[TD="width: 120, bgcolor: transparent"]
3.76​
[/TD]
[TD="width: 120, bgcolor: transparent"]
4.70​
[/TD]
[TD="width: 120, bgcolor: transparent"]
5.64​
[/TD]
[TD="width: 120, bgcolor: transparent"]
15​
[/TD]
[TD="width: 120, bgcolor: transparent"]
10​
[/TD]
[TD="width: 246, bgcolor: transparent"]
32.258​
[/TD]
[TD="width: 276, bgcolor: transparent"]
1.270​
[/TD]
[TD="width: 140, bgcolor: transparent"]
4.303​
[/TD]
[TD="width: 120, bgcolor: transparent"]
2.54​
[/TD]
[TD="width: 120, bgcolor: transparent"]
3.18​
[/TD]
[TD="width: 120, bgcolor: transparent"]
4.23​
[/TD]
[TD="width: 120, bgcolor: transparent"]
5.29​
[/TD]
[TD="width: 120, bgcolor: transparent"]
6.35​
[/TD]
[TD="width: 120, bgcolor: transparent"]
16​
[/TD]
[TD="width: 120, bgcolor: transparent"]
11​
[/TD]
[TD="width: 246, bgcolor: transparent"]
35.814​
[/TD]
[TD="width: 276, bgcolor: transparent"]
1.410​
[/TD]
[TD="width: 140, bgcolor: transparent"]
5.313​
[/TD]
[TD="width: 120, bgcolor: transparent"]
2.82​
[/TD]
[TD="width: 120, bgcolor: transparent"]
3.53​
[/TD]
[TD="width: 120, bgcolor: transparent"]
4.70​
[/TD]
[TD="width: 120, bgcolor: transparent"]
5.88​
[/TD]
[TD="width: 120, bgcolor: transparent"]
7.05​
[/TD]
[TD="width: 120, bgcolor: transparent"]
17​
[/TD]
[TD="width: 120, bgcolor: transparent"]
14​
[/TD]
[TD="width: 246, bgcolor: transparent"]
43.002​
[/TD]
[TD="width: 276, bgcolor: transparent"]
1.693​
[/TD]
[TD="width: 140, bgcolor: transparent"]
7.650​
[/TD]
[TD="width: 120, bgcolor: transparent"]
N/A​
[/TD]
[TD="width: 120, bgcolor: transparent"]
N/A​
[/TD]
[TD="width: 120, bgcolor: transparent"]
N/A​
[/TD]
[TD="width: 120, bgcolor: transparent"]
N/A​
[/TD]
[TD="width: 120, bgcolor: transparent"]
N/A​
[/TD]
[TD="width: 120, bgcolor: transparent"]
18​
[/TD]
[TD="width: 120, bgcolor: transparent"]
16​
[/TD]
[TD="width: 246, bgcolor: transparent"]
57.328​
[/TD]
[TD="width: 276, bgcolor: transparent"]
2.257​
[/TD]
[TD="width: 140, bgcolor: transparent"]
13.600​
[/TD]
[TD="width: 120, bgcolor: transparent"]
N/A​
[/TD]
[TD="width: 120, bgcolor: transparent"]
N/A​
[/TD]
[TD="width: 120, bgcolor: transparent"]
N/A​
[/TD]
[TD="width: 120, bgcolor: transparent"]
N/A​
[/TD]
[TD="width: 120, bgcolor: transparent"]
N/A​
[/TD]
</tbody>
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Question Question
Index, match and sum formula problem with Multiple Criteria
Replies
4
Views
690
buster01
B

Forum statistics

Threads
1,224,823
Messages
6,181,175
Members
453,021
Latest member
Justyna P

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top