Xlookup function from Zero to Hero

Text Lookup We will begin by using xlookup to look up text, very much like vlookup does. Below is a partial screen shot of our data from the worksheet “Text Lookup” showing general economic situation of various parts of the world. Question: What is the price to income ratio of Australia? Answer: =XLOOKUP(“Australia”,’Text Lookup’!A:A,’Text Lookup’!B:B,,0,1) … Continue reading Xlookup function from Zero to Hero