How do i stop a Vlookup formula's column index number from changing when a table expands to include new data.
=VLOOKUP('SHIFT REPORT'!$G$5:$G3838,'Drop Down Lists'!$G$2:$J$30,4,0)
The column index number (4) keeps changing to a 3 when the table expands.
Bookmarks