An curved arrow pointing right. Once you have mastered VLOOKUP in Excel it's time to move on to INDEX/MATCH. This formula combination gives the same results but without the problems of VLOOKUP.

Finally, the col_index_no is the column in ... the final argument blank or type TRUE, VLOOKUP will accept approximate matches ...

and I want an exact match (FALSE). One key difference between VLOOKUP and XLOOKUP is that the former requires me to specify a column index number where the result will be found, whereas the latter ...