Writing a value in a specific cell (number=line)

Ok. So here's the deal. All i want to do is when i write a number, "7" for example in cell B2 then automatically the value 2 is written in cell B7. If i write "14" then the value 2 is written in cell B14 etc.

So the number that i am writing is actually the number of the line that i need to write a value too.

If also you can make it work backwards it would be really nice.

Thank you for your time.

Hello Scandal, welcome to the forum.

Can you explain a bit more in context what you are trying to achieve? Maybe post a workbook that illustrates what you want to do.

Also, it is not clear if you are after a VBA or a formula solution.

in b3 dragged down
=IF(ROW()=$B$2,2,"")
you can't have that and what you ask as you;'d overwrite formula.