Use INDEX combined with MATCH as in:
=INDEX($B1:$B5;MATCH("alpha";$A$1:$A$5;0))
MATCH gets the row number in the reference range.
INDEX gets the value in the lookup range in that row.
Kirill S. Palagin wrote:
Hello.
I am hitting the problem where I need to return value of cell with
VLOOKUP and if cell contains 0, result seems to be string, which can not
be used in math formulas. When I refer directly to cell (=Sale.D250) it
correctly returns zero.
Problem described clearly in last 3 comments to
http://www.openoffice.org/issues/show_bug.cgi?id=8088
How do people work around that?
Thanks a lot.
WBR,
K. Palagin.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Send instant messages to your online friends http://au.messenger.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
