Greetings,
The semicolon is used as my separator because my locale (Canadian
French) wants decimal commas.
In such a case, the list separator is changed to the semicolon to
remove the chance of conflict between a number (1 1/2 is written as 1,5
and not 1.5) and its position in the list. The same
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
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
