Match data from 3 columns to return data from the correct 4th column

[klwilliams13wf]

Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the spreadsheet I'm working with below. I want to manually enter a number in C4, and in E4, and then pick a number from a drop down box in G4, and have it auto-populate the corresponding lbs/sq ft in N4 based on a chart on another worksheet. I've pasted a copy of the chart below as well. Is this possible??

 

[kweaver]

Welcome to Mr. Excel
Would you please provide a few examples, including the results you expect from your examples?
Also, it would help those trying to help you if you use XL2BB so that we don't have to reenter your data.

In your example, do you want an answer of 11.513...?

 

[klwilliams13wf]

Welcome to Mr. Excel
Would you please provide a few examples, including the results you expect from your examples?
Also, it would help those trying to help you if you use XL2BB so that we don't have to reenter your data.

In your example, do you want an answer of 11.513...?

Oh, I'm sorry!! I didn't post a full list of data in my table! Ok, so let's change the thickness to 3/8 or .375; what I would like returned in N4 would be 17.27.

I'm sorry for sounding ignorant, but what is XL2BB?

 

[kweaver]

Posting Data use XL2BB version 2 (18th Jan 2021)

 

[kweaver]

Does this accomplish it?

=SUM((Q2:Q8=E2)*(R2:R8=C2)*(S2:S8=G2)*T2:T8)

 

[klwilliams13wf]

oh, I see it!!

Does this accomplish it?

=SUM((Q2:Q8=E2)*(R2:R8=C2)*(S2:S8=G2)*T2:T8)

No... I want it to look up the WT/ft in the chart, based on what I enter in the depth, width and thickness of the chart. so if I enter 5/8 in x 5/8 in x 1/16 in thick, it will enter .442 as the wt/ft

 

[kweaver]

Book1
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	QTY	WIDTH	UNIT	DEPTH	UNIT	THICK	UNIT	LENGTH	UNIT	WELD	EXT	UNIT	LBS/UNIT			D	W	THICK	WT/FT
2	10	0.625	in	0.625	in	0.0625	IN	10	IN		100		0.442			1	1	0.12	1.437
3																1	1	0.075	0.945
4																5/8	5/8	0.0625	0.442
5																3/4	3/4	0.048	0.457
6																3/4	3/4	0.06	0.552
7																1 1/2	1 1/2	0.083	1.602
8																4	4	0.375	17.27
Sheet1

Cell Formulas
Range	Formula
C2,Q4:R4,E2	C2	=5/8
N2	N2	=SUM((Q2:Q8=E2)*(R2:R8=C2)*(S2:S8=G2)*T2:T8)
Q5:Q6	Q5	=3/4

Of course, you'll have to change the reference to where the table is located.

 

[kweaver]

Book1
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	QTY	WIDTH	UNIT	DEPTH	UNIT	THICK	UNIT	LENGTH	UNIT	WELD	EXT	UNIT	LBS/UNIT			D	W	THICK	WT/FT
2	10	1 1/2	in	1 1/2	in	0.083	IN	10	IN		100		1.602			1	1	0.12	1.437
3		4		4		0.375							17.27			1	1	0.075	0.945
4		3/4		3/4		0.06							0.552			5/8	5/8	0.0625	0.442
5																3/4	3/4	0.048	0.457
6																3/4	3/4	0.06	0.552
7																1 1/2	1 1/2	0.083	1.602
8																4	4	0.375	17.27
Sheet1

Cell Formulas
Range	Formula
N2:N4	N2	=SUM(($Q$2:$Q$8=E2)*($R$2:$R$8=C2)*($S$2:$S$8=G2)*$T$2:$T$8)
Q4:R4	R4	=5/8
Q5:Q6	Q5	=3/4

 

[klwilliams13wf]

Book1
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	QTY	WIDTH	UNIT	DEPTH	UNIT	THICK	UNIT	LENGTH	UNIT	WELD	EXT	UNIT	LBS/UNIT			D	W	THICK	WT/FT
2	10	1 1/2	in	1 1/2	in	0.083	IN	10	IN		100		1.602			1	1	0.12	1.437
3		4		4		0.375							17.27			1	1	0.075	0.945
4		3/4		3/4		0.06							0.552			5/8	5/8	0.0625	0.442
5																3/4	3/4	0.048	0.457
6																3/4	3/4	0.06	0.552
7																1 1/2	1 1/2	0.083	1.602
8																4	4	0.375	17.27
Sheet1

Cell Formulas
Range	Formula
N2:N4	N2	=SUM(($Q$2:$Q$8=E2)*($R$2:$R$8=C2)*($S$2:$S$8=G2)*$T$2:$T$8)
Q4:R4	R4	=5/8
Q5:Q6	Q5	=3/4

maybe I didn't enter the formula right, but I'm getting a value error... the table that has the data I want to pull from is on another tab "Lists". Would that be causing the problem. I'm just lost! I copied the formula =SUM(($Q$2:$Q$8=E2)*($R$2:$R$8=C2)*($S$2:$S$8=G2)*$T$2:$T$8) and pasted it into the cell that I want to have the wt/ft populate. Is that right?

 

[klwilliams13wf]