Let's say you are interested in setting up the Data worksheet using XLOOKUP function in such a way that when you provide a couple ID value as input, Excel automatically fetches the corresponding SC Index value as output. Further assume that you will place your input in cell J2 and want the output to appear in cell K2. In order for XLOOKUP function to work correctly in this scenario you will need to type your formula exactly as _______________ in cell _____. XLOOKUP(J2,A2:A275,G2:G275); K2
