Cells with the same value all the time

[McLareNas]

problem (1).xlsxAs suggested I created new thread asking for help to solve my problem. A bit similar problem was solved in this thread http://www.excelforum.com/excel-prog...-the-time.html

I uploaded a file. There we have sports results in two different tables. Left one is in groups, right is done according to a schedule. Similar like in previous situation i want to have the same value all the time in "Score" columns. Right table is made with index-match function (same as vlookup). So for example i want that values in cells J33 and V12 would be the same. But if i change number (column D) do a different value, right table should also catch its correct value. In a worksheet score is with index-match function but it should just a value. The main idea is that i want to able to add result to each of those two tables and no needing to correct anything after that

[McLareNas]

So nobody's knows??

[Solus Rankin]

I'm not sure I understand. It seems you already have a solution. I changed the value in J12 and V5 changed just fine.

[McLareNas]

I reuploaded the file in the first post.

Xero, you're right - if you change J12, V5 is fine. But if you change V5, J12 is not fine. The thing is that I want to be able to change any of these (for example J12 or V5) and other one have to change automatically how it should. Also if I change number in D column right table also have to adjust correctly