Convert All Vlookup formulas to Index-Match in a worksheet

[littleiitin]

Hi Everyone,

I have seen many requests at work to convert Vlookup formulas into Index match.

Wrote a code which will convert all vlookup formula of a worksheet into Index match formula on a single click.

The only limitation - this will not convert any Vlookup which is appearing between other formula.

Thanks
Rahul