WHat I'm trying to do is actually move the pointer from the "c11" cell to the
cell "d11" cell. I have been able to figure out move the data from one cell
to another. What I have set up and am trying to do, is a form in excell where
I have yes, no, and don't know data cells. If a student puts a "x" in the yes
cell, I want to then have the pointer move to the next "yes" cell in the next
row down.

Thanks!!

"QC Coug" wrote:

The following formula will look at c11 and if it is x it will pull the value
for d11. If it isn't X then it will be blank ("").

=if(c11=€�x€�,d11,"")

"Copper6203" wrote:

Is there a "go to" function in Excel? What I want to do is have a conditional
if statement where if data in the previous cell equals a given variable, then
you would be automatically redirected to another cell.

This is what Im trying to do: =if(c11=€�x€�,go to d11)

Thanks in advance!!!!