Copy VLOOKUP formula in different columns:

[@mohammadj.shamim9342]

Instead use curly brackets and enter the number of columns in the column index placeholder. {2,3,4,5}. It works for sparsely located columns too.

[@chuken1067]

If the sequence of Physics, mathematics…..are not the same, I think it is better to use the “Match” formula to find the columns

[@MONICALAMPAS]

NA always appears. What do I need to do?

[@Touse107]

Just Xlookup?