Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

At 15:09 24/07/2012 -0700, Kuuga Noname wrote:
I found a really weird problem today when I was rearranging the sheets, to make them easier to read and find important information quickly. I moved the equipment tables with your formula to the first sheet and no matter what, the formula only works if the tables begin in column A. I then moved the original table and the same thing happened there. Why is this? I tried to move the weapon table to the same column and re-make the weapons array but that didn't do the trick either.

Nothing weird about it! The third parameter of the VLOOKUP() function indicates the column number in the table from which data will be harvested. Note that this is the column number *within the table*, not the number of the spreadsheet column - so it shouldn't matter if you move the source table about.

In your original arrangement, the values you needed to appear in column C were to be harvested from the second column of the source table, those for D from the third, and so on. The formula COLUMN()-1 does this: it represents the number one fewer than the (spreadsheet) column number of the destination column. If you move the destination table horizontally, you will just have to modify that formula - to COLUMN()-2 or whatever.

Brian Barker

For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.