Hi. How does on repeat this formula down a column, without changing the table array numbers?
I want this:
=VLOOKUP(A2,C2:D100,2,FALSE)
=VLOOKUP(A3,C2:D100,2,FALSE)
=VLOOKUP(A4,C2:D100,2,FALSE)
=VLOOKUP(A5,C2:D100,2,FALSE)
But right now I end up with this:
=VLOOKUP(A2,C2:D100,2,FALSE)
=VLOOKUP(A3,C3:D101,2,FALSE)
=VLOOKUP(A4,C4:D102,2,FALSE)
=VLOOKUP(A5,C5:D103,2,FALSE)
Bookmarks