Hi,

I'm not sure how to solve this.

My workbook's structure is protected. The sheets are protected as well. I
am using Excel 2003.

I have a group of cells B360:B389 which are user input cells. My formulas
use VLookup. The trouble is the user can drag the cells within the user
range and this trashes the VLookups.

Is there a way to restrict their ability to drag cells? Or perhaps another
solution?

I have tried this with and without the $ before the 360 but the formulas
still Ref.

Column B:
User input

Column E:
=IF($B360<"",VLOOKUP($B360&"*",$E$44:$O$346,1,FAL SE),"")

Column H:
=IF($B360<"",VLOOKUP($B360&"*",$E$44:$O$346,11,FA LSE),"")

--
Thanks for your help.
Karen53