OOo (currently using GO-OO on my work machine) doesn't seem to support entire column ranges, such as VLOOKUP(A1,B:C,2,FALSE). I have to do VLOOKUP(A1,B1:C999999,2,FALSE). Is there some syntax that I am missing? When I import an Excel sheet that uses B:C, it gets replaced with B$1:C$1048576. Is there a good reason why B:C is not an option?
Phil. -- Don't you just hate self-referential sigs? -- E-mail to [email protected] for instructions on how to unsubscribe List archives are available at http://www.libreoffice.org/lists/users/ All messages you send to this list will be publicly archived and cannot be deleted
