[Solved] I need help with VLOOKUP

[Dakress]

So I have the following problem:
I want to make an enormous sheet with a lot of VLOOKUP. However I don't want to change the last number in said VLOOKUP.

An exsample:
VLOOKUP($B25;Sheet2.$A$(§:G$G$90;2)

If I want to drag that now to the right it should look like this:
VLOOKUP($B25;Sheet2.$A$(§:G$G$90;3)

Is there any faster way to do that other then by changing the 2 to 3 in hundreds of cells?

[Zizi64]

VLOOKUP($B25;Sheet2.$A$(§:G$G$90;2)

If I want to drag that now to the right it should look like this:
VLOOKUP($B25;Sheet2.$A$(§:G$G$90;3)

What is that § sign in the function??? And what is single the parenthese (without a pair) before it???

Please upload a real ODF file here with working sample formula inside.

[Zizi64]

You can use helper cells...:

VLOOKUP_increase column.ods

(10.46 KiB) Downloaded 87 times

(And use the 4th parameter - with zero value - for the unsorted tables.)