Hi...

I'm doing a VLOOKUP function, and my cell range will be the same for all rows, but when I auto-fill, it changes my cell range by one-- other than manually typing in that cell range everytime, is there a way I can override the auto-fill?

Example:
THIS happens:
VLOOKUP(A2, Sheet2!A2:A6, etc)
VLOOKUP(A3, Sheet2!A3:A7, etc)
VLOOKUP(A4, Sheet2!A4:A8, etc)

I need THIS:
VLOOKUP(A2, Sheet2!A2:A6, etc)
VLOOKUP(A3, Sheet2!A2:A6, etc)
VLOOKUP(A4, Sheet2!A2:A6, etc)

I've tried manually filling in 3 cells, then auto-filling when all 3 cells are selected, and all that does is change my data table range to A5:A9 for 3 rows, then A9:A13 for 3 rows, etc...

TIA!!

Don't judge me for playing with spreadsheets on a Friday night