View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pixiemom pixiemom is offline
external usenet poster
 
Posts: 2
Default 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