Avatar of agwalsh

asked on 

Using index/match with columns and rows - tables and how to automatically copy

I'm attaching a file. In the formulas sheet I have set up the first column (B - Carlow heading in table) to use index match to pull in the matching data from the Housing survey sheet. I get that I can copy/paste across and amend Carlow to matching counties. But if I wanted to just be able to copy this formula across...what tweak do I need to add to the formula to do this?
Microsoft Excel

Avatar of undefined
Last Comment
Professor J

8/22/2022 - Mon