Transferring data

Occasional Visitor

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! 



2 Replies


You can use 





I'd suggest to transform database into structural table (Ctrl+T) or at least use dynamic ranges. After that any lookup function, as @Quadruple_Pawn suggested or XLOOKUP, depends on your Excel version.