[libreoffice-users] vlookup with cell reference for range

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