Hello,
Right now im using an index/match formula to return a value in a 4th column based on the values of the first 3 columns. This was working great until I expanded the formula down thousands of rows and the workbook slowed down considerably. Now I'm looking for a way to capture this functionality in a macro.
This is the formula I use now:
=INDEX('Sheet1'!$A$1:$D$1736,MATCH($C$1&$C$2&$A7,'Sheet1'!$A$1:$A$1736&'Sheet1'!$B$1:$B$1736&'Sheet1'!$C$1:$C$1736,0),4)
I would like to use worksheetfunction.match to just fill in the data, but I could not find the right syntax (if it is even possible) for matching multiple columns. Does anybody know the right syntax or another way to replicate this functionality?
Right now im using an index/match formula to return a value in a 4th column based on the values of the first 3 columns. This was working great until I expanded the formula down thousands of rows and the workbook slowed down considerably. Now I'm looking for a way to capture this functionality in a macro.
This is the formula I use now:
=INDEX('Sheet1'!$A$1:$D$1736,MATCH($C$1&$C$2&$A7,'Sheet1'!$A$1:$A$1736&'Sheet1'!$B$1:$B$1736&'Sheet1'!$C$1:$C$1736,0),4)
I would like to use worksheetfunction.match to just fill in the data, but I could not find the right syntax (if it is even possible) for matching multiple columns. Does anybody know the right syntax or another way to replicate this functionality?
