"Csaba Gabor" wrote in message
...
VLOOKUP requires sorted order of the lookup column, which
was implied to be not the case by my having a third argument
of 0 for MATCH. But even if that were not the case, VLOOKUP
is essentially the same technology as MATCH, HLOOKUP,
and LOOKUP and does not address either of my questions.


It doesn't if you use FALSE as the last argument as I did.

It addresses it as I read it, not directly because I believe there is a
better way than your approach, but the objective.


Q1: In a spreadsheet, is there any formula that can deal
with the formula in another cell or the reference returned
by such formula (eg. =Books!R4C1)?

Q2: When MATCH returns a cell value that has a hard newline
(entered via Alt+Enter), how does one get that to display as
a newline instead of showing a box symbol?

Just in case, this is on Excel 2003 under Win XP Pro

Csaba