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! 

excel.png

 

2 Replies

@hma12340 

You can use 

=VLOOKUP(E3,$B$3:$C$6,2,0)

or

=INDEX($C$3:$C$6,MATCH(E3,$B$3:$B$6,0))

@hma12340 

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.