Pergunta de entrevista da empresa Guidehouse

what is substitute function. what is xlookup