Vlookup Help in Excel

[rmiller11]

I have a formula which I am looking up figures in another sheet:

=VLOOKUP(A1,Sheet1!1:65536,4,FALSE)

The problem is, that when I copy the formula down, this is what happens:

=VLOOKUP(A2,Sheet1!#REF!,4,FALSE)

I want the second, third, and forth section to stay constant:

Sheet1!1:65536,4,FALSE) How do I do that?

 

[Dreamboat]

What are the columns?
You don't show them in =VLOOKUP(A1,Sheet1!1:65536,4,FALSE)

Do yourself a favor. Select the range that you need to lookup in (at least 4 columns) and hit insert-name-define and call it myrange. Then change your formula to:

=VLOOKUP(A1,myrange,4,FALSE)

Otherwise, a valid vlookup would be:

=VLOOKUP(A1,Sheet1!$A$1:$D$65536,4,FALSE)

Anne Troy
Way cool stuff:

http://www.cafeshops.com/OfficeExperts