# Selecting Entire Columns for VLOOKUP

SHIFT+CTRL+DOWN is one way to get around it, but if there are spaces, seperated chunks of data or any other irregularities in the list of data this can be tedious.

One hint: You may select a column (or two) first and copy the range shown in the editable control leftmost in the “Formula Bar” and paste it to the proper parameter position of your function. For the columns A and B this is “A1:B1048576”.

Be modest with huge ranges. Calc must have a chance to cope with the task.

=VLOOKUP(C1,A:B,1,

Isn’t recognized by LibreOffice because the exact range of cells in the array isn’t specified. One must select the exact range (A1:B15) for it to function, and while this seems like a minor additional task when working with small arrays, it’s not economical when scaled to hundreds, thousands or tens of thousands of rows of data. So I was hoping this wasn’t an oversight and I was just missing some simple function when working with formulas in Libre.

Your hint does solve the issue I imagine. Selecting first the columns I need to parse, then grabbing that absolute cell range in the cell range field, but does that hold the same dynamic functionality as A:B does in Excel? Will my formula actually try parsing through A1:B1048576 absolutely even though I only have values in A1:B:54000? Because A:B in Excel functions in that it parses only the range that contains actual values.

(C1,A:B,1,

Some combinations of characters containing parentheses and punctuation marks are abused in this editor for creating smileys and other “special effects”. I too would prefer to have every character coding for itself.