Cell referencing issue

**CanadienKid25** · 11-05-2010, 10:17 AM

I am referencing another cell on a worksheet that has imported data from the web but when i refresh the data connection, i lose the cell reference in the formula and it goes to #REF!

Example:

=IF(ISNUMBER(DailyStatsData!A216),DailyStatsData!B216,"")

changes to

=IF(ISNUMBER(DailyStatsData!#REF!),DailyStatsData!#REF!,"")

The DailyStatsData sheet is imported data from the web that is always in the same format.

Can someone help me out? How should i be inputing the formula so that when i refresh the data i don't get a #REF! error

**JBeaucaire** · 11-05-2010, 11:19 AM

Maybe use a construct like this instead:

=IF(ISNUMBER(INDEX(DailyStatsData!A:A, 216)), INDEX(DailyStatsData!A:A, 216),"")

**DonkeyOte** · 11-05-2010, 11:25 AM

May also be worth checking the properties of the web query itself - if you set to Overwrite rather than Insert does that resolve your issue in the first instance ?