Sort values in Table

Hello,

From my last thread http://www.excelforum.com/excel-gene...rt-values.html

I successfully achieved what was suggested and when i changed the value in G3 everything updated as required.

But since i tried this in the real data it is failing to update the table correctly.

Column C i am using Vlook up to get the values in this column
Column D i am referencing another sheet to get these values.

My question does now that i have the first 2 columns using formula's effecting the way the table sorts.
if so how can i update this.

Thanks for your help with this.