I have a
VLOOKUP and when I do the pull down formula copy (The black cross on the bottom right of the original cell) method although the formula copies the table array cells also change so that the range of cells.
It isn't what I need, I can't seem to work out a way of keeping the same cell range in the formula's without manually copy and pasting the formula into every cell
Forumla is as follows:
=VLOOKUP(Table1[[#All],[Service Tag]], '[Master record on a new sheet in excel]'!A2:D30,2, FALSE)
However, when I copy down the formula the "A2:D30" increments each time; A3:D31 etc. which is not what i want i want the formula to be exactly the same in each cell; is there a way to accomplish this without manually copy and pasting it in each time?