Solved

# excel vlookup

Posted on 2012-08-28
367 Views
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.
0
Question by:doctorbill

LVL 12

Accepted Solution

=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

LVL 12

Assisted Solution

You can anchor the range by putting a \$ in front of the row number.

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

Author Closing Comment

Thanks to all
0

## Featured Post

I've recently been in need of an Excel macro that could add a letter before the text on multiple cells in an Excel document. My English is as it is, so I will try explain what it does diffrently. If you have an excel document with 2000 rows an…
Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…