In VLOOKUP, col_index_no is a static value which is the reason VLOOKUP doesn’t work as a dynamic function. If you are working...