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