Thread: How do I copy a VLOOKUP into a column and keep a constant array?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lars-Åke Aspelin[_2_] Lars-Åke Aspelin[_2_] is offline
external usenet poster
  
Posts: 913
Default How do I copy a VLOOKUP into a column and keep a constant array?
On Sat, 26 Jul 2008 08:15:01 -0700, Bobby6901
wrote:

I am trying to copy a VOOKUP formula down a column, and
Excel wants to change the reference array as I move to lower rows. How do I
stop that?


Use $ in the reference of your lookup vector, like this

=VLOOKUP(C1,A$1:B$10, 2)

Hope this helps / Lars-Åke
Reply With QuoteReply With Quote