IF Statements

[MarkAndrews]

I know you can only nest 7 IF statements in a standard formula

My question is, How can i do more?

TIA

 

[MarkAndrews]

Mark

What do you want to do involving the IFs? Return a client ID given some other value? What's the other value? Is a VLOOKUP appropriate here?

Richard

If client ID = 10, Return the client name (just as a standard IF does)

I suppose I could use Vlookup off a table?

 

[MarkAndrews]

Mark

So why not use a VLOOKUP?

And why not give us some more information?

Thats all the info i can really Give Norie

I just want the IF Facility, but extend if from 7 to 22 options

Is it possible to nest more than 7 IF's in one IF Statement, if not i'll use a table and utilise Vlookup

Thanks

 

[Norie]

Mark

You've hardly given us any information as far as I can see.

We don't know what data you have.

We don't know how that data, if it exists, is organised.

We don't actually know what you want to do.

 

[MarkAndrews]

Here's a sample of the data, Column A contains the Client ID's

What i'm after doing is place an IF statement (containing 22 IF's) in Column K, which will return the corresponding client name to the client ID

Hope this is a little better on the explanation?

The data is sorted by StartDate, ascending

Abort Data.xls
	A	B	C	D
1	ClientID	IntroducerID	MatterID	StartDate
2	10	40	563785	03/01/06
3	10	40	563787	03/01/06
4	21	33	563790	03/01/06
5	21	33	563791	03/01/06
6	10	40	563792	03/01/06
7	10	40	563793	03/01/06
8	10	40	563795	03/01/06
9	10	40	563796	03/01/06
10	1	NULL	563800	03/01/06
11	10	15	525439	03/01/06
12	24	2	563813	03/01/06
13	10	40	563821	03/01/06
14	10	40	563823	03/01/06
15	10	15	563826	03/01/06
16	14	NULL	563827	03/01/06
17	14	NULL	563831	03/01/06
18	14	NULL	563841	03/01/06
19	14	NULL	563842	03/01/06
20	14	NULL	563844	03/01/06
21	14	NULL	563847	03/01/06
22	14	NULL	563849	03/01/06
23	1	17	563869	03/01/06
24	15	NULL	563883	03/01/06
25	10	15	563888	03/01/06
26	18	NULL	563899	03/01/06
27	10	17	563906	03/01/06
28	23	32	563916	03/01/06
Jan

 

[Norie]

So where is the client name data?

 

[MarkAndrews]

So where is the client name data?

Sorry, On a sheet called "Workings"

A2-B23

 

[Peter_SSs]

So where is the client name data?

Sorry, On a sheet called "Workings"

A2-B23

What about posting a sample of theis "Workings" sheet?

 

[MarkAndrews]

So where is the client name data?

Sorry, On a sheet called "Workings"

A2-B23

What about posting a sample of theis "Workings" sheet?

Sorry

As requested

Abort Data.xls
	A	B	C	D
1	ClientID			IntroducerID
2	1	Halifax		1
3	4	Pru-New		2
4	8	STL		3
5	9	NatWest		4
6	10	GenericSAP		5
7	11	Virgin		6
8	14	WOL		7
9	15	WoolINT		8
10	16	CAG		9
11	17	NOR		11
12	18	BBS		12
13	19	RBS		13
14	20	FirstActive(PAD)		15
15	21	FirstActive(REM)		17
16	22	OffsetNatWest(REM)		18
17	23	OffsetRBS(REM)		19
18	24	OffsetNatWest(PAD)		20
19	25	OffsetRBS(PAD)		21
20	26	Tesco		22
21	27	Oneaccount		23
22	28	IF		24
23	99	GenericRem		25
Workings

 

[Peter_SSs]

So in cell K2 of 'Jan' sheet, what about
=VLOOKUP(A2,Workings!$A$2:$B$23,2,0)
and copy this down?

 

[MarkAndrews]

Excellent, Could i do the same with the introducer too?

Abort Data.xls
	D	E	F	G
1	IntroducerID
2	1	Bradford&BingleyEstateAgents		1
3	2	NationalWestminsterHomeLoansLtd		2
4	3	BarclaysHomeFinance		3
5	4	CharcolOnline		4
6	5	LegalMove		5
7	6	LegalMovePhone		6
8	7	PrudentialBankingplc		7
9	8	GeorgeWimpeyUKLtd		8
10	9	Townends		9
11	11	HammondsDirect		10
12	12	Alliance&Leicesterplc		11
13	13	FirstConveyancingLtd		12
14	15	YourMove		13
15	17	Halifax		14
16	18	ResourceTechniquesLimited		15
17	19	IntelligentFinance		16
18	20	KeyworkersLiving		17
Workings