Re: [libreoffice-users] vlookup with cell reference for range

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 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:
> =VLOOKUP(1,J1,2,0)
> the formula doesn't works
> also if J1 is =ADDRESS(1,1, , )&":"&ADDRESS(5,3, , )
>
> how can I get vlookup function working with cell reference for range??
>
> manythanx, :-) ciao, pier


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted