Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the following statement, as it stands it works fine, but I would like
to expand on it and have it lookup three more cells. The problem is that statement is then too long. I was wondering if anyone had any suggestions on how to make the statement shorter and still do what I need it to, or another way of accomplishing this. =IF(ISNA(VLOOKUP(' Form 2'!R31,'Employee List'!F1:G132,2)),"",VLOOKUP(' Form 2'!R31,'Employee List'!F1:G132,2)) & CHAR(10) & CHAR(10) & "and further that " & CHAR(10) & CHAR(10) &("2. ") &(' Form 2'!AF4&" "&' Form 2'!AY4&" "&' Form 2'!I4) & CHAR(10) & CHAR(10) & IF(ISNA(VLOOKUP(' Form 2'!R32,'Employee List'!F1:G132,2)),"",VLOOKUP(' Form 2'!R32,'Employee List'!F1:G132,2)) & CHAR(10) & CHAR(10) & "and further that " & CHAR(10) & CHAR(10) &("3. ") &(' Form2 '!AF4&" "&' Form 2'!AY4&" "&' Form 2'!I4) & CHAR(10) & CHAR(10) & IF(ISNA(VLOOKUP(' Form 2'!R33,'Employee List'!F1:G132,2)),"",VLOOKUP(' Form 2'!R33,'Employee List'!F1:G132,2)) I would like to add: & CHAR(10) & CHAR(10) & "and further that" & CHAR(10) & CHAR(10) &("4. ") &(' Form 2'!AF4&" "&' Form 2'!AY4&" "&' Form 2'!I4) & CHAR(10) & CHAR(10) & IF(ISNA(VLOOKUP(' Form 2'!R34,'Employee List'!F1:G132,2)),"",VLOOKUP(' Form 2'!R34,'Employee List'!F1:G132,2)) & CHAR(10) & CHAR(10) & "and further that" & CHAR(10) & CHAR(10) &("5. ") &(' Form 2'!AF4&" "&' Form 2'!AY4&" "&' Form 2'!I4) & CHAR(10) & CHAR(10) & IF(ISNA(VLOOKUP(' Form 2'!R35,'Employee List'!F1:G132,2)),"",VLOOKUP(' Form 2'!R35,'Employee List'!F1:G132,2)) & CHAR(10) & CHAR(10) & "and further that" & CHAR(10) & CHAR(10) &("6. ") &(' Form 2'!AF4&" "&' Form 2'!AY4&" "&' Form 2'!I4) & CHAR(10) & CHAR(10) & IF(ISNA(VLOOKUP(' Form 2'!R36,'Employee List'!F1:G132,2)),"",VLOOKUP(' Form 2'!R36,'Employee List'!F1:G132,2)) Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Long If Statement | Excel Worksheet Functions | |||
IF statement too long, need another way | Excel Worksheet Functions | |||
very long statement | Excel Discussion (Misc queries) | |||
Long IF Statement | Excel Discussion (Misc queries) | |||
long if statement | Excel Programming |