Hi all,

Is it possible in excel to do teh following

1- move the selection to a new location based on a certain criteria? for
example, IF(A1=C4 Then move the cell selection to D4)

2- make an IF statement with multiple results...for example, =IF(A1=A3, 100
AND D8=200....etc)...the idea is to make an IF statemetn such that, IF A1=A3,
Then the current cell should be 100 and the cell next to it should be 200,
and the cell next to that one should be 300...and so on...

Thank you