Excel

Copper Contributor

A number between 1 and 4 Will be written in Amy cell and if this number is 1 for example How I can ensure that the formula I write selects a1, if it is 2, selects a2 if it is 3, selects cell a3 and operates with it ? 

1 Reply

@Mehmet39 Something like this?

Riny_van_Eekelen_0-1712317421314.png

Example attached.