• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

updating a value after processing

D

Duffer

New Member
when using vlookup to select a value to process , then when processed the value is used to update its original cell value , as it is now i am stuck in a loop , any ideas anyone ,

Regards , Duffer .
 
Hi Duffer,

Could not understood your requirement, be more clear in explaining it, may be supplement your problem with a sample file.

Regards,
 
H Somendra ,
What i am trying to do is use vlookup to get values for Home attack and defence also away attack and defence then when the values are processed to give the predicted scores and when actual scores available take actual scores from predicted scores then this gives the adjustments for the future games , but i cant get h11 , h12 , j11 , j12 to update the Hull City and Everton base data .

NOTE H4 and j4 are dropdown lists
 

Attachments

@Duffer

I am still confused about your problem, you are getting values in H5,H6,J5 & J6 based on your base table. Now in H11,H12,J11 & J12 you are doing some addition and subtraction, now where do you want to update these values? In your base table?

Regards,
 
Hello again Somendra
The values to be updated are Hull City attack & defence n5 & o5 also the same for everton attack & defence n9 & o9 ,
Regards ,
 
@Duffer

But if you update the data in base table than the result of VLOOKUP will change and since they all are dependent that will create a circular ref. error.

Regards,
 
Somendra Misra said:
@Duffer

But if you update the data in base table than the result of VLOOKUP will change and since they all are dependent that will create a circular ref. error.

Regards,
Click to expand...
That is the problem i want to update the data columns after the actual scores are entered which will give new values for the next games , looks like i will have to change my approach to the problem ,

Regards , Duffer .
 
Duffer said:
That is the problem i want to update the data columns after the actual scores are entered which will give new values for the next games , looks like i will have to change my approach to the problem ,

Regards , Duffer .
Click to expand...
Hello Again ,

I have more thoughts about trying to update data columns , but cant work out how to do the tech stuff , here is what i am thinking , the data for the updating sent to a to a block of cells then copied to the data columns , but using a macro which when a button is clicked the data is copied to the data base columns , in this way if data can be copied in a macro then there would be no looping effect, i hope i have explained this ,
Duffer
 
You must log in or register to reply here.
Back
Top