Question: will xlookup replace index match?
Answer: The XLOOKUP Function is meant to replace both the VLOOKUP and HLOOKUP Functions. It will also replace the INDEX / MATCH function combo that was previously used to perform more powerful VLOOKUPs. ... So be careful using the XLOOKUP Function – make sure your end-users have access to the new function.