That's got it.

Thanks for your help Frank


-----Original Message-----
Hi Tim

sorry my fault. Replace all occurences of CHR(10) with
CHAR(10)

Frank

Frank Kabel wrote:
Hi Tim
try

=IF(ISNA(VLOOKUP('Sheet2'!R33,'Sheet10'!
F1:G59,2)),"",VLOOKUP('Sheet1'!
R33,'Sheet10'!F1:G59,2)) & CHR(10) &

IF(ISNA(VLOOKUP('Sheet2'!R34,'Sheet10'!
F1:G59,2)),"",VLOOKUP('Sheet1'!R
34,'Sheet10'!F1:G59,2)) & CHR(10) &

IF(ISNA(VLOOKUP('Sheet2'!R35,'Sheet10'!
F1:G59,2)),"",VLOOKUP('Sheet1'!R
35,'Sheet10'!F1:G59,2)) & CHR(10) &

IF(ISNA(VLOOKUP('Sheet2'!R36,'Sheet10'!
F1:G59,2)),"",VLOOKUP('Sheet1'!R
36,'Sheet10'!F1:G59,2))

Frank



Tim wrote:
I would like to use a multiple LOOKUP statement.
What I have so far is:



=IF(ISNA(VLOOKUP('Sheet2'!R33,'Sheet10'!
F1:G59,2)),"",VLOOKUP('Sheet1'!R33,'Sheet10'!F1:G5 9,2))
This is in a large cell (basically a text box)
What I would like to do is add LOOKUPs from Sheet1 R34,
R35 and R36, I would like them to drop down a line or
two
(new paragraph) then post the text.
Each VLOOKUP, if there is data in R34, R35 or R36
would be
a new paragraph in this large cell.
Is it possible to force it to drop down a line?


.