Here's the screen shot:

Interview? Schedule Interview
Yes #VALUE!

and here's the formula I have in cell K7:

=IF(J7+"Yes",sheet3!C2," ")

"Eduardo" wrote:

Hi Karen,
could you provide an example with indication or your final result, thank you

"Karen D" wrote:

I thought that might work but it doesn't bring the cursor to that cell in
Sheet2, it pulls whatever value is in that cell...there used to be a "goto"
function I thought...?


"Eduardo" wrote:

Hi,
in cell B7 you can enter

=if(a7="YES",sheet2!A1,"")

if cell a7 = Yes, B7 will pull the information from sheet2 cell A1 otherwise
will be blank

"Karen D" wrote:

If a condition is met in a cell (A7='Yes'), I want it to go to another sheet
in the sameworksheet. Does anyone have any suggestions on how to do this?