I am using that, I have many other worksheets that use the same pull data from web function with the same type of index,match formula and it never changes. I wasn't sure if there was something I didn't know about happening going on here. So the from web data basically pulls the webpage I dictate the table off said page and it inserts the table in "A1" and overwrites the data that was in there previously. As I stated before I have many other worksheets that does this with the same formula getting data from the tables and they don't change my formulas. I was hoping there may have been a setting or something I wasn't aware of causing this issue.