Conditional Vlookup

**mclaude** · 10-17-2013, 12:58 PM

Good day,

I have a table containing a field with two values or conditions. I want to create a conditional vlookup to return only names based on one of the two conditions like the last column (Out_Call_Type) on the attached.

Anyone with an idea on how to go about this?

Thanks.

**Pete_UK** · 10-17-2013, 01:28 PM

How about including some example data in your file, along with an indication of what you want to get from it?

Pete

**popipipo** · 10-17-2013, 01:34 PM

Have you tried a pivot table?

**AlKey** · 10-17-2013, 01:45 PM

For "P" criteria

=IFERROR(INDIRECT("B"&SMALL(IF($D$3:$D$14="P",ROW($B$3:$B$14),""),ROW(A1))),"")

For "T" criteria

=IFERROR(INDIRECT("B"&SMALL(IF($D$3:$D$14="T",ROW($B$3:$B$14),""),ROW(A1))),"")

Both are array formulas and must be confirmed with Ctrl+Shift and ENTER

You also need to remove spaces from D column in order for formulas to work

	B	C	D	E	F	G
2	Name_Surname	Dialled_DIGITS	Out_Call_Type
3	Lorna	453236458	P		Lorna	Kelly
4	ISAAC	453005468	P		ISAAC	Chad
5	MELISSA	453639940	P		MELISSA	Lucy
6	Kelly	462569801	T		Whitey	Cindy
7	Whitey	534589378	P		SYDWELL
8	SYDWELL	167093464	P		Kim
9	Chad	237643982	T		Cenotia
10	Kim	936945357	P		Samantha
11	Lucy	166795646	T
12	Cenotia	704694128	P
13	Cindy	644597318	T
14	Samantha	234236497	P

Conditional Vlookup

LinkBack

Thread Tools

Rate This Thread

Display