Opposite of a $ sign in formulas?

[kuriti]

This is probably an easy question, but it has got me stumped...

I am dragging alot of Vlookup formulas and I want the column inde
number to increase by one for each cell. Normally it does thi
automatically for other parts of the function, but not there. I know t
stop it automatically adding you put a "$" in front of the column o
row.

Is there an $ doppleganger that forces the number to change

 

[Guest]

I've had problems with this before, usually when I was
unnecessarily defining the sheet in a formula. Sometimes,
when you are referring back and forth in a fomula, Excel
starts putting the Sheet1! in front of your cell
reference, even though you are referencing the same sheet
the formula is on. If this is the case, try deleting the
sheet reference.

 

[Don Guillett]

Am I missing something or did you answer your own question.

 

[Gord Dibben]

kuriti

Assume Table to be A1:E50

=VLOOKUP($F$1,Table,{1,2,3,4,5},FALSE)

Select G:K in row 1.

Enter the above formula in G1 then hit CRTL + SHIFT + ENTER to array-enter it.

Gord Dibben Excel MVP