Agree 100%! Since I started using it, I have not used the ‘VLOOKUP’ at all. And the brilliant thing is that adding a column in the middle of your referenced cells (as in VLOOKUP) does not mess up your matched value (as in Index:Match)
Agree 100%! Since I started using it, I have not used the ‘VLOOKUP’ at all. And the brilliant thing is that adding a column in the middle of your referenced cells (as in VLOOKUP) does not mess up your matched value (as in Index:Match)