Forum Discussion
AutoPopulation of fomulas by column help
Hi, I have 2 sheets in a workbook. I would like to pull data from sheet 2 into sheet 1. rather than manually referencing the cells I want, I would like to be able to pull down my reference formula, while keeping the row it is pulling from the same, but changing the reference column. Please see attached excel file. Thank you for any help.
You could use an INDEX-XMATCH. My only concern would be how additional data would be added to Sheet 2:
=INDEX(Sheet2!A4:L4, , {0,1} + XMATCH(A3:A5, Sheet2!$2:$2))Could you explain what each part of that formula does? I am trying to make it work with my actual spreadsheet (which is a little more complicated than the test file i attached screen shots of)
Here's a snip of my notes I added to the workbook. I've also attached the workbook.
