On 2021-06-14 20:25, Thomas Blasejewicz wrote:
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.
...
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?
Tools > Options > LibreOffice Calc > Formula > Separators
--
To unsubscribe e-mail to: [email protected]
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
