Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How to select entire column while using vlookup function in calc

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.

How to select entire column while using vlookup function in calc

While using the V Look up function in calc, how do I select the entire column. 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.

How to select entire column while using vlookup function in calc

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.error. EDIT: From version 5.0, It is now possible to specify references to entire columns or rows using the A:A or 1:1 notation instead of A1:A1048576 or A1:AMJ1

How to select entire column while using vlookup function in calc

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. error.

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

How to select entire column while using vlookup function in calc

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 now possible to specify references to entire columns or rows using the A:A or 1:1 notation instead of A1:A1048576 or A1:AMJ1