VBA function to replace all occurrence of "VLOOKUP" and "HLOOKUP" with either new "XLOOKUP" formula or "INDEX/MATCH" combo in Excel.
Handles absolute/relative/named ranges, references on other sheets, both match types and even incorporates wrapped "IFERROR" inside XLOOKUP.
lookup_replace.bas contains all necessary functions
test.xlsb contains examples and unit test
XLOOKUP replacement script will intentionally ignore V/HLOOKUPs with 4th argument = TRUE if the indexing array is not sorted, that is to ensure that behavior stays the same