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, w...
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.