VBA Convert Index to Direct Link

Hi I am looking to convert a series of Index formulas to direct links.

I have found topics which do this for Indirect formulas but have been unable to find anything on the topic of indexes.

Example Formula : INDEX('Sheet 2'!$1:$1048576,MATCH($A4,'Sheet 2'!$A:$A,0),MATCH(F$1,Sheet2'!$1:$1,0))

Which would return 127 and 50 in the row_num and column_num: INDEX('Sheet 2'!$1:$1048576,127,50)

I this instance I would want a direct link through to 'Sheet 2'!AX127 because the array range is $1:$1048576.

If the array was B2:BZ200 then it would return AY128

The last consideration is that there may be multiple indexes in the formula which needs converting.

I would really appreciate some guidance on the subject.
Regards Bean

Error Post....

Could you please explain your last post.
Was your problem solved?

I'm having a similar problem, wonder if anyone could help

I have a formula:
=INDEX(Sheet1!$1:$1048576,$D15,MATCH(G$14,Sheet1!5:5,0))

Which I would like simplified down to its direct equivalent
=B8

I am attaching a sheet

Also in case it helps, this is not the answer, but on a related point there is an example of how to trace from an Index Match Match function to the ultimate source:
google stackoverflow VBA to trace precedents of index function
[sorry the software won't let me post direct link]

Thanks in advance