Hello all. I just have a quick question. I'm using the VLOOKUP function and copying the formula to numerous cells below the initial. When I copy the cells, the table range increases by one number each time I move down a row.
I do not want the table range to change as I copy this formula. How do I prevent this from doing so?
A remedial question from an Excel novice. Any help would be appreciated.
Thank you.
I do not want the table range to change as I copy this formula. How do I prevent this from doing so?
A remedial question from an Excel novice. Any help would be appreciated.
Thank you.