Urgent - vlookup and sort

Hi Friends

I have to compare two sheet values and if there is a change then I update a status with "Y or N" on the first sheet. This I have done successfully. After that If I sort this STATUS COLUMN, then my values are getting changed. for example while update the staus I get 8 N and 6 Yes. But, If sort on this column (in my example D) then I get only 4 yes and rest are no. this is result is wrong. I used vlookup in my sample and I need your help. Advance thanks.