VLOOKUP help

[Tim]

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:G59,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?

 

[Frank Kabel]

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]

Frank, I'm getting #NAME?
I don't know if it's something I'm doing or not

 

[Frank Kabel]

Hi Tim

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

Frank

 

[Tim]

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


F1:G59,2)),"",VLOOKUP('Sheet1'!
F1:G59,2)),"",VLOOKUP('Sheet1'!R
F1:G59,2)),"",VLOOKUP('Sheet1'!R
F1:G59,2)),"",VLOOKUP('Sheet1'!R




.