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+unsubscr...@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