Hi

Does anyone have a macro that can convert the following formula to entirely absolute references? I have about 900 rows to convert and as you can see the reference in the second set of parentheses isn't completely absolute. This is because I need to reference the specific row that it is on. However, when I sort the data I need it to lock in its original row. Any ideas?

=INDEX('Title1'!$A$1:$H$126, MATCH(Master!$A2,'Title1'!$A:$A,0), MATCH(Master!$K$1,'Title1'!$1:$1,0))