StijnRoelen
New Member
- Joined
- Sep 8, 2021
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hi All,
I have a large database with 460.478 unique "Postal Codes".
I also have a workbook in which I want to fill in one of the "Postal Codes" and as a result get the "Municipality" and "Water Authority" for that specific Postal Code.
Right now i have a simple but working solution which is
=VLOOKUP(D4;'C:\Users\Stijn\Documents\[Database.xlsx]Sheet1'!$A$2:$C$460479;2;FALSE)
except when i do it like this the file size of my workbook increases from 2,5 MB to over 12 MB. Since we use many unique copies of this workbook this is not acceptable and i feel like there should be a way to retrieve two cells per single request without increasing the size by that much.
Thanks in advance!
I have a large database with 460.478 unique "Postal Codes".
I also have a workbook in which I want to fill in one of the "Postal Codes" and as a result get the "Municipality" and "Water Authority" for that specific Postal Code.
Right now i have a simple but working solution which is
=VLOOKUP(D4;'C:\Users\Stijn\Documents\[Database.xlsx]Sheet1'!$A$2:$C$460479;2;FALSE)
except when i do it like this the file size of my workbook increases from 2,5 MB to over 12 MB. Since we use many unique copies of this workbook this is not acceptable and i feel like there should be a way to retrieve two cells per single request without increasing the size by that much.
Thanks in advance!
