excel vlookup

I have a question the VLOOKUP formula

Example:
=VLOOKup(C1,D1:F100,2,FALSE)

If I enter this formula into a cell and then use autofill to drag the formula down to the following cells, the values increase by 1 each time. Is there a way of stopping the value of F increasing  by 1 each time. I don't see the need for this  unless it is the way the formula needs to work.
doctorbillAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
AlanConnect With a Mentor ConsultantCommented:
=VLOOKup(C$1,D$1:F$100,2,FALSE)

Or more likely:

=VLOOKup(C1,$D$1:$F$100,2,FALSE)

if you want the C reference to track down, but the lookup area to be fixed.

You might also want to fix the column ref on the C ref:


=VLOOKup($C1,$D$1:$F$100,2,FALSE)


HTH,

Alan
0
 
Jared_SConnect With a Mentor Commented:
You can anchor the range by putting a $ in front of the row number.


=VLOOKup(C1,D$1:F$100,2,FALSE)
0
 
doctorbillAuthor Commented:
Thanks to all
0
All Courses

From novice to tech pro — start learning today.