Dec 03 2021 08:04 AM
Hi All!
I have an excel database contains 2000 buildings' postcode and its work area (for my job). I have now been given another spreadsheet with only the postcode (4000 items with repeated buildings), but I will need to fill in the area for the new spreadsheet. Is there any formula/ quick way that allow me to do it? Please see the example image below. Thank you very much!
Dec 03 2021 08:16 AM
Dec 03 2021 08:22 AM
I'd suggest to transform database into structural table (Ctrl+T) or at least use dynamic ranges. After that any lookup function, as @OliverScheurich suggested or XLOOKUP, depends on your Excel version.