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)

Work Week #:	Week 1	Week 2	Week 3	Week 4	Week 5	Week 6	Week 7	Week 8	Week 9	Week 10
Topic
Subject 1
Category 1	0	0	N/A	0	0	0	0	0	0	0
Category 2	0	0	N/A	0	0	0		0	0	0
Category 3	0	0	N/A	1	0	0	0	0	0	0
Category 4	0	0	N/A	0	0	0	1	0	0	0
Category 5	0	0	N/A	0	0	0	0	0	0	0
Category 6	0	0	N/A	0	1	0	0	0	0	0
Subject 2
Category 1	0	0	N/A	0	0	0	0	0	0	0
Category 2	0	0	N/A	1	0	0	0	0	0	0
Category 3	0	0	N/A	0	0	0	0	0	0	0
Category 4	0	0	N/A	0	0	0	0	0	0	0

<tbody>
</tbody>