Lookup unique value in multiple columns

Edit: Are you still using Excel 2003 as your profile shows? If not please update your profile to show which version. It's important ... for example Fluff's AGGREGATE function was introduced in Excel 2010.

Another way.

In F2 this and filled down.

Formula:

=INDEX($D$2:$D$13,MATCH(2,INDEX(1/MMULT(--($A$2:$C$13=$E2),{1;1;1}),0)))

	A	B	C	D	E	F
1	ID 1	ID 2	ID 3	Names
2	5077		8130	Bob	5077	Bob
3	9492			John	5893	Rachel
4	7432		3120	Mike	4396	Elsie
5	5702			Jacob
6	3858	6630	9075	Kelly
7	2401	4196	2275	Martha
8	2327		5935	Joe
9	6496	2570	5893	Rachel
10	3258			Liz
11	2738	4396		Elsie
12	7777		9754	JoAnne
13	5522	9983		Allen