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