Mar 14 2023 05:13 AM - edited Mar 14 2023 05:18 AM
Hi all,
I am currently trying to insert data on local authority income into the top table. My issue is I have multiple observations for each local authority (as seen in top picture) so cannot just copy and paste the two columns. For example, for each 'Barking and Dagenham' observation I would like 2 columns for income 2019 and 2022 each reading £27,104 and £30,006 respectively. I would just copy and paste across and drag down but I have so many local authorities that it doesn't seem feasible.
Any help would be greatly appreciated please!
Many thanks!
Mar 14 2023 07:04 AM
If I'm understanding what you're seeking, the VLOOKUP function (or any of many variations on that classic Excel function, also available at the page I've linked to) would give that to you. Something like
=VLOOKUP(B2,incometable,2,0), where
By the way, =VLOOKUP(B2,incometable,3,0) would be used to get the second income value, the offset being to the third column.
If you want further help in implementing that, please post a copy of your actual spreadsheet(s) on OneDrive or GoogleDrive and paste a link here. Images are useful to a certain extent, but the actual files more useful.
Mar 16 2023 03:21 AM
Mar 16 2023 07:52 AM