Adding Index Match Formula inside a cell with the use of Macros

[raven1124]

Hello Guys,

I'm in need of your professional help with this one as I have observed that my excel file tends to get slow when I add the function for Index + Match in each cell. I've observed that my sheet tends to load right after I made changes with the database sheet that I'm using to reference the value of each cell in a column.

He's the sample formula that I've used for each cell to get my desired result: =IFERROR(INDEX(Database!$DF:$DF,MATCH($C$5&D$11,Database!$C:$C&Database!$M:$M,0)),"N/A")

Would it be possible to use a loop for this one and if it possible, can the values be pasted only instead of the formula to void the lag inside the worksheet.


Sample Table below: (Note: the cells with 0,1 & N/A would mean that I used the Index + Match for each of them)
[TABLE="width: 736"]
<tbody>[TR]
[TD]Work Week #:[/TD]
[TD]Week 1[/TD]
[TD]Week 2[/TD]
[TD]Week 3[/TD]
[TD]Week 4[/TD]
[TD]Week 5[/TD]
[TD]Week 6[/TD]
[TD]Week 7[/TD]
[TD]Week 8[/TD]
[TD]Week 9[/TD]
[TD]Week 10[/TD]
[/TR]
[TR]
[TD]Topic[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Subject 1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Category 1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]N/A[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Category 2[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]N/A[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Category 3[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]N/A[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Category 4[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]N/A[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Category 5[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]N/A[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Category 6[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]N/A[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Subject 2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Category 1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]N/A[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Category 2[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]N/A[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Category 3[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]N/A[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Category 4[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]N/A[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]