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 |
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) |