Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 79
Default stopping value(from cell) from increasing when vlookup copied down

I have the following formula:

=VLOOKUP(F1,'[Source Table.xls]Policies'!$A$4:$U$28,B9+1,FALSE)

the value of F1 is a month which must be constant (but can be changed for
each month if you see what i mean)

how can i make the formula treat F1 as constant when it is copied down?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,316
Default stopping value(from cell) from increasing when vlookup copied down

Enter F1 in the formula as an absolute reference:

Enter $F$1 when you type the function, or after type F1 press the F4 key to
create an absolute reference.

or if the formula has already been entered:

Highlight the F1 cell address in either the cell itself or the formula bar
and press the F4 key.
--
Kevin Backmann


"PBcorn" wrote:

I have the following formula:

=VLOOKUP(F1,'[Source Table.xls]Policies'!$A$4:$U$28,B9+1,FALSE)

the value of F1 is a month which must be constant (but can be changed for
each month if you see what i mean)

how can i make the formula treat F1 as constant when it is copied down?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
increasing a cell value on each use dave Excel Worksheet Functions 3 July 27th 07 11:06 PM
Stopping a constant variable cell from being copied. Link New Users to Excel 3 May 15th 07 03:35 AM
increasing a cell by 1 Debra Excel Worksheet Functions 3 October 6th 06 04:41 PM
Stopping the Fx Window from dropping down when clicking in a cell Sara Excel Discussion (Misc queries) 3 June 24th 06 02:38 AM
Stopping free text entry in validation cell smf Excel Discussion (Misc queries) 2 December 15th 05 07:44 PM


All times are GMT +1. The time now is 10:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"