Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup-cell range in formula changes when copied to another cell
I've sent up several "forms" on one worksheet. When I copy the "master form"
under another, the cell range in the vlookup formula changes. I need the cell range in the formula to remain the same no matter where it is copied in the worksheet. Any suggestions? example: =VLOOKUP(B39,'Other Crystals & Findings'!A1:B225,2) I need it to always remain A1:B225. Thanks, Pixiemom |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup-cell range in formula changes when copied to another cell
Use absolute references like below
=VLOOKUP(B39,'Other Crystals & Findings'!$A$1:$B$225,2) Even better Create a NAME (eg Lookup_Table) for the range 'Other Crystals & Findings'!$A$1:$B$225 and use that... like =VLOOKUP(B39,Lookup_Table,2) "pixiemom" wrote: I've sent up several "forms" on one worksheet. When I copy the "master form" under another, the cell range in the vlookup formula changes. I need the cell range in the formula to remain the same no matter where it is copied in the worksheet. Any suggestions? example: =VLOOKUP(B39,'Other Crystals & Findings'!A1:B225,2) I need it to always remain A1:B225. Thanks, Pixiemom |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup-cell range in formula changes when copied to another c
Thank you so much! I knew there was an answer out there somewhere.
Thanks, Pixiemom "Sheeloo" wrote: Use absolute references like below =VLOOKUP(B39,'Other Crystals & Findings'!$A$1:$B$225,2) Even better Create a NAME (eg Lookup_Table) for the range 'Other Crystals & Findings'!$A$1:$B$225 and use that... like =VLOOKUP(B39,Lookup_Table,2) "pixiemom" wrote: I've sent up several "forms" on one worksheet. When I copy the "master form" under another, the cell range in the vlookup formula changes. I need the cell range in the formula to remain the same no matter where it is copied in the worksheet. Any suggestions? example: =VLOOKUP(B39,'Other Crystals & Findings'!A1:B225,2) I need it to always remain A1:B225. Thanks, Pixiemom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
stopping value(from cell) from increasing when vlookup copied down | Excel Discussion (Misc queries) | |||
Formula when copied into a new cell doesn't recalculate | Excel Discussion (Misc queries) | |||
Unwanted formula being copied to cell | Excel Discussion (Misc queries) | |||
cell format changes when formula copied? | Excel Worksheet Functions | |||
I get a 0 value when a formula is copied to another cell | Excel Discussion (Misc queries) |