Ross Johnson wrote:
Sandeep Jain wrote:
Hi,
I am not able to put a vlookup in openoffice i want to pull some data
from a different sheet . Can you pls help me or let me know what is
the formula for the same ASAP.
What have you tried so far? E.g. Formulas etc.
Hey... how about
=VLOOKUP("Criteria";'Sheet Name'.A2:B6;2;0)
Where "Criteria" is what you are looking for
'Sheet Name' is the sheet name
A2 is the upper left of the range you are looking in, B6 is the lower right
2 is the column the answer comes from (you are searching in the first
column)
0 or false because my data was not sorted and I wanted an exact match.
I know it wasn't ASAP but I am new to OOo and thought you meant there
was not a VLOOKUP function so I was thinking about how one would
construct such a function.
WalterAM
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
