How do I fill down and only increment part of a formula?

English
#1

The C2 is all I want to increment.

=LOOKUP(C2,Alphabets.F1:Alphabets.F26,Alphabets.B1:Alphabets.B26)
=LOOKUP(C3,Alphabets.F1:Alphabets.F26,Alphabets.B1:Alphabets.B26)
=LOOKUP(C4,Alphabets.F1:Alphabets.F26,Alphabets.B1:Alphabets.B26)

#2

=LOOKUP($C2,$Alphabets.$F$1:$F$26,$Alphabets.$B$1:$B$26)

Note that all parts except the 2 are prepended with $ which denotes absolute reference.

See Addresses and References, Absolute and Relative in online help.

See also this question.

#3

Works perfectly. Thanks for the references.

#4

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.