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 INDIRECT https://help.libreoffice.org/Calc/Spreadsheet_Functions#INDIRECT Cheers, Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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