Hello I'm using 2.2 OpenOffice.org. My problem is, I can't use VLOOKUP and
SUMIF function just like what it does in Microsoft Office. The example is
when I create a list of names (james,micky,jhon,willy,me) from A1:A5 and a
list of numbers (1,2,3,4,5) from B1:B5 and I try to look for james and I
create the search cell in C1 but I wrote just j . With this program
[=VLOOKUP(C1;A1:B5;2)] it shows me #N/A and when I wrote m it shows me 1.
Why when I not even wrote the full name I still have answer? and it's more
trouble when I use a lot of names.
I think it's just about time for me to tell you about this. Because it's
very important to me now. At least I hope you've read my message and could
answer the question or more even can give me an advice, but please be more
caution about vlookup and sumif.
And last of all I want to apologize if there's mistake in my message but
your considere is what I need the most
Thank you very much
