matching multiple columns

[twalters1]

I have data in columns c,d and e on sheet 1 (with each row representing one entry) that I add to periodically and I have a fixed set of data on sheet 2 with 4 columns (a,b,c and e). I would like to match column c with column a on sheet 2, column d with column b on sheet 2 and column e with column c on sheet 2. when they all match, I would like to populate column h on sheet one with the information in column e from sheet two in the row where all three columns match. I have more than 64 rows in my table on sheet 2 so I can't use nested ifs. How can I do this?

 

[JoeMo]

Welcome to the Forum. Here's one way to do this. Copy the formula in Sheet1 H1 down to cover your data range.

Excel Workbook
	C	D	E	F	G	H
1	17O4	nH77	tXcS			info1
2	s4uZ	4Huk	bjT5			info2
3	hLdJ	HQ2v	14oZ
4	Zfz5	3HDZ	9aC7			info4
5	XLbs	039k	E3bT			info5
6	16Ki	iuxk	F54g			info6
7	9sA1	j9QC	K2WE			info7
8	Sv5l	j748	nMK0			info8
9	JWYI	93M4	g1Av
10	6ErK	7Vl4	7TV2			info10
11	S75g	115O	cqXG			info11
12	c6J7	bT3N	n7MF			info12
13	50cX	0EcH	9lUj			info13
14	t603	3DC6	h434
15	Em47	8TiC	v11E			info15
16	KcqD	wS28	Fd3X			info16
17	u4UF	Kvsi	3ILB			info17
18	KeOo	FyvU	N6Rj			info18
19	g63c	255W	2O2i			info19
20	EtU8	KkrY	90jD			info20
Sheet1

Excel Workbook
	A	B	C	D	E
1	17O4	nH77	tXcS		info1
2	s4uZ	4Huk	bjT5		info2
3	hLdJ	HQ2v			info3
4	Zfz5	3HDZ	9aC7		info4
5	XLbs	039k	E3bT		info5
6	16Ki	iuxk	F54g		info6
7	9sA1	j9QC	K2WE		info7
8	Sv5l	j748	nMK0		info8
9		93M4	g1Av		info9
10	6ErK	7Vl4	7TV2		info10
11	S75g	115O	cqXG		info11
12	c6J7	bT3N	n7MF		info12
13	50cX	0EcH	9lUj		info13
14	t603		h434		info14
15	Em47	8TiC	v11E		info15
16	KcqD	wS28	Fd3X		info16
17	u4UF	Kvsi	3ILB		info17
18	KeOo	FyvU	N6Rj		info18
19	g63c	255W	2O2i		info19
20	EtU8	KkrY	90jD		info20
Sheet2

 

[twalters1]

That worked great! I worked on this for almost 2 hours and could only get it to work partially with nested ifs. Thank you so much!! Hopefully it won't take me as long to figure out what this formula actually does

Welcome to the Forum. Here's one way to do this. Copy the formula in Sheet1 H1 down to cover your data range.
Sheet1

*	C	D	E	F	G	H
1	17O4	nH77	tXcS	*	*	info1
2	s4uZ	4Huk	bjT5	*	*	info2
3	hLdJ	HQ2v	14oZ	*	*	*
4	Zfz5	3HDZ	9aC7	*	*	info4
5	XLbs	039k	E3bT	*	*	info5
6	16Ki	iuxk	F54g	*	*	info6
7	9sA1	j9QC	K2WE	*	*	info7
8	Sv5l	j748	nMK0	*	*	info8
9	JWYI	93M4	g1Av	*	*	*
10	6ErK	7Vl4	7TV2	*	*	info10
11	S75g	115O	cqXG	*	*	info11
12	c6J7	bT3N	n7MF	*	*	info12
13	50cX	0EcH	9lUj	*	*	info13
14	t603	3DC6	h434	*	*	*
15	Em47	8TiC	v11E	*	*	info15
16	KcqD	wS28	Fd3X	*	*	info16
17	u4UF	Kvsi	3ILB	*	*	info17
18	KeOo	FyvU	N6Rj	*	*	info18
19	g63c	255W	2O2i	*	*	info19
20	EtU8	KkrY	90jD	*	*	info20

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:34px;"><col style="width:33px;"><col style="width:64px;"></colgroup><tbody>
</tbody>

Spreadsheet Formulas

Cell Formula H1 {=IF(ISNA(MATCH(C1&D1&E1,Sheet2!$A$1:$A$20&Sheet2!$B$1:$B$20&Sheet2!$C$1:$C$20,0)),"",INDIRECT("Sheet2!E"&MATCH(C1&D1&E1,Sheet2!$A$1:$A$20&Sheet2!$B$1:$B$20&Sheet2!$C$1:$C$20,0)))} <tbody> </tbody>

Formula Array: Produce enclosing { } by entering formula with CTRL+SHIFT+ENTER!

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

Sheet2

*	A	B	C	D	E
1	17O4	nH77	tXcS	*	info1
2	s4uZ	4Huk	bjT5	*	info2
3	hLdJ	HQ2v	*	*	info3
4	Zfz5	3HDZ	9aC7	*	info4
5	XLbs	039k	E3bT	*	info5
6	16Ki	iuxk	F54g	*	info6
7	9sA1	j9QC	K2WE	*	info7
8	Sv5l	j748	nMK0	*	info8
9	*	93M4	g1Av	*	info9
10	6ErK	7Vl4	7TV2	*	info10
11	S75g	115O	cqXG	*	info11
12	c6J7	bT3N	n7MF	*	info12
13	50cX	0EcH	9lUj	*	info13
14	t603	*	h434	*	info14
15	Em47	8TiC	v11E	*	info15
16	KcqD	wS28	Fd3X	*	info16
17	u4UF	Kvsi	3ILB	*	info17
18	KeOo	FyvU	N6Rj	*	info18
19	g63c	255W	2O2i	*	info19
20	EtU8	KkrY	90jD	*	info20

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:64px;"><col style="width:71px;"><col style="width:73px;"><col style="width:64px;"></colgroup><tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[JoeMo]

That worked great! I worked on this for almost 2 hours and could only get it to work partially with nested ifs. Thank you so much!! Hopefully it won't take me as long to figure out what this formula actually does

Happy it works for you - thanks for letting me know.