# How to select entire column while using vlookup function in calc [closed]

While using the V Look up function in calc, how do I select the entire column? In google doc the formula =VLOOKUP(B8,Sheet1!B:D,3,0) perfectly works for selecting the entire B,C and D columns. But in Calc the formula returns error.

**EDIT: From version 5.0, It is possible to specify references to entire columns or rows using the A:A or 1:1 notation instead of A1:A1048576 or A1:AMJ1**

@Kunjomachen : This was announced in the release notes in this place. I tried to verify it with 5.0.0.0beta3 without success. Did you verify it already with a newer prerelease?

@Lupp Yes, I verified it on LO Version: 5.0.0.4 Build ID: cf112dc905650fb985306a7a03d2fe3fcc6c978f

I use LO 4.3.7 and I change the settings into Excel A1 for the Formula Syntax from Tools > Options > Libreoffice Calc > Formula and it's okay to use like VLOOKUP(D1,G:I,3,0)

You will get some possibly unwanted changes in the syntax of references this way, too. These may cause formulae using the INDIRECT() function, e.g, to fail. I therefore would disadvise to go this way. In addition: V5.0 will already allow for referencing complete columns/rows (like A:A, 1:4, B:Z) . V5.0.0 will soon be released.

Thanks for your suggestion.