[libreoffice-users] specify an absolute sheet address

Good evening
I am probably, again!, too stupid to figure this out by myself,
so I would be grateful for a hint.

I have a file with something like 25 sheets listing the patients who 
visited my clinic before
grouped by year. In one sheet I have all names (about 2,000).

To make my work easier I set up a VLOOKUP function to help me enter zip 
codes.
In sheet 2021 that formula looks like
=VLOOKUP(N77,'Zip codes'.$A$2:$B$150,2,0)
and refers to a sheet with the zip codes 3 sheets to the right. This 
works fine.

However, when I copy the data (whenever there is something new) to the 
"ALL" sheet to the right of 2021,
I get a "N/A", because the formula AGAIN refers to the THIRD sheet to 
the right, that does not have any zip codes.

I tried to figure out, how to specify the sheet "Zip codes" as the 
absolute address,
like:     =VLOOKUP(N76,$zip codes.$a$2$:$zip #REF!.$B$220,2,0)
but so far all attempts (for quite a while now!) at placing those $ 
marks have resulted in errors.

I am sure, this is something very simple, but being a simpleton I just 
cannot figure it out.

Thank you.
Thomas

--
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