Hi there Philip and Mynda - Happy New Year!
I have downloaded the UK PAF (Postcode Address File) with 29million rows split into 6 separate files and want to use it to look up several thousand postcodes I have in another workbook and return the street address. If the PAF was (a lot) smaller I would just use XLOOKUP, so what tools do I need in order to achieve this?
Many thanks
Robert
Hi Robert,
I would put all 29 million rows in a single CSV file. Use Power Query to get the CSV file and do the lookup in Power Query using Merge Tables.
Mynda
Thank you, Mynda. I'll give that a try.
All best wishes to you, Philip and your great team.
Thanks, Robert! And you to 🙂
Just to confirm that answer regarding the 29 million rows worked a treat. Thanks again.
Great to hear! Thanks for letting us know.