Forum Discussion
Table Header Lookup
JonHowarth Perhaps a little bit of clean-up with Power Query (integrated in Excel 2016 and newer) and a pivot table could do all of this without complicated formulas. See the attached file for an example.
Not sure though if this works in the 2016 version, as I'm loading data directly into the pivot table. Perhaps you need to go via an regular Excel table. Give it a try. May seem haunting at first but it's really not difficult.
More about PQ in the link below.
https://exceloffthegrid.com/power-query-introduction/
JonHowarth Perhaps a little bit of clean-up with Power Query (integrated in Excel 2016 and newer) and a pivot table could do all of this without complicated formulas. See the attached file for an example.
Not sure though if this works in the 2016 version, as I'm loading data directly into the pivot table. Perhaps you need to go via an regular Excel table. Give it a try. May seem haunting at first but it's really not difficult.
More about PQ in the link below.
https://exceloffthegrid.com/power-query-introduction/
- This actually worked perfectly, your query didn't load properly in 2016 but it was enough that I could remake it in my sheet. It's a bit fiddly choosing the postcode through the pivot table but I can make this easier using splicers.
Thanks for the help!
