Re: [libreoffice-users] specify an absolute sheet address (SOLVED)

On 2021/06/13 2:55, Johnny Rosenberg wrote:
> Another way to get around it is to name your range. Then your formula 
> could
> look something like =VLOOKUP(N76;ZipCodes;2;0)
> Named ranges are absolute, always.
>
>
> Kind regards
>
> Johnny Rosenberg
After futile efforts to make all those symbols work somehow, I recalled 
you mentioning "naming a range".
Since I did not know, there is such a concept, I did some reading and 
after a few experiments - I hope! - I may actually have solved my problem.
Defining the data range in the sheet "Zip codes", naming it "zipcodes" 
(this setting apparently does not accept spaces),
the formula seems to be working .. AND .. looks a lot friendlier!
=VLOOKUP(N79,zipcodes,2,0)

Your idea was VERY helpful! Thank you.
Even I can understand that formula.
(You used semicolons in your formula, mine has commas. Is there a 
difference?
Greetings from Japan where it is sunny (and rather hot) today, but we 
are about to enter the rainy season ...
Thomas Blasejewicz

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy