using libreoffice Version 4.0:build-305 on my opensuse 12.3
I would like to have a reference in the VLOOKUP function for range:
the VLOOKUP formula is:
=VLOOKUP(criteria,range,index,sort)
if I write the function:
=VLOOKUP(1,$A$1:$D$5,2,0)
function works
but
if J1 is $A$1:$D$5
and the formula:
Hi,
Am 03.11.2013 18:19, schrieb yahoo-pier_andreit:
the VLOOKUP formula is:
=VLOOKUP(criteria,range,index,sort)
if I write the function:
=VLOOKUP(1,$A$1:$D$5,2,0)
function works
but
if J1 is $A$1:$D$5
and the formula:
=VLOOKUP(1,J1,2,0)
the formula doesn't works
Try the function
What I have done that works is first name the region. Then I place the
region name in a cell, then us indirect(cell with range name). hth
gs
On 11/3/2013 11:19 AM, yahoo-pier_andreit wrote:
using libreoffice Version 4.0:build-305 on my opensuse 12.3
I would like to have a reference in the