hello all
I am using the following formula to pull information from one sheet and
place it on another.
=IF(ISNA(HLOOKUP(B1,FieldHours!$A2:FieldHours!IV20 0,2,FALSE)),"NOT
LISTED",(HLOOKUP(B1,FieldHours!$A2:FieldHours!IV20 0,2,FALSE)))

The document is used to track field time and other info.

The problem that i am having is that every week i get the book and
excel has changed the first and second FieldHours!$A2 to a $ref!.

I can not figure out why excel is doing this.

should i be using something other than IV200 for the end of my search.

Is there any way to keep excel from changing my fomulas. If i go back
and make it the same as it was it seems to work for that sheet only.

If anyone would like to see the book let me know and i will email it to
you.
Dbalish at roncomachine com


--
DanBal
------------------------------------------------------------------------
DanBal's Profile: http://www.excelforum.com/member.php...o&userid=24079
View this thread: http://www.excelforum.com/showthread...hreadid=395403