Link to a number entered in a cell!

[owendodd]

Hi

What i am trying to do is i have a cell C4. This is where i am going to input a number. These numbers reside on a column B. They also reside on another sheet in the workbookWhat i want to do is when i enter a number into C4 it will automatically go find the row this number is on, on another. Any ideas?

I want to find a value on the current sheet and once entered in it links you to it on another sheet! A macro!

Cheers thanks!

 

[fairwinds]

Yes think I understand what you are trying to do thus my suggestion.

If you click on the cell with the formula, it should take you to the appropriate cell in SCHEDULE2. Without a macro. Is this not what you want?

 

[owendodd]

Thanks for your help but still a little issue with your form

Thanks for your assistance,

what i tried with this

=HYPERLINK(CELL("address",INDEX(SCHEDULE2!B:B,MATCH(C4,Sep!C:C,0))))

I have change it to this because the MATCH is between sheet SCHEDULE2 and sheet Sep with the respective columns. It comes with cannot find specified file when i click on the link.

Any ideas.

 

[fairwinds]

Your file must be saved first.

 

[owendodd]

No it is saved, it just comes up with a cannot open specified file!

 

[fairwinds]

What does the cell with the formula say?

It should be something like:

[Book1.xls]SCHEDULE2!$B$5


I still believe the formula should be:

=HYPERLINK(CELL("address",INDEX(SCHEDULE2!B:B,MATCH(C4,SCHEDULE2!C:C,0))))

 

[owendodd]

Yeah the formula is something like that.

=HYPERLINK(CELL("address",INDEX(SCHEDULE2!A:A,MATCH(C3,Sep!C:C,0))))

I have the formula like this because i am matching the worksheet SCHEDULE2 with the worksheet Sep along with the columns that have the data in them.

Why would you think that the formula would be

=HYPERLINK(CELL("address",INDEX(SCHEDULE2!B:B,MATCH(C4,SCHEDULE2!C:C,0))))

Many Thnaks for your assistance in this

 

[fairwinds]

You should answer my first question.
That is to ensure that you actually get a match.


Or you could test the MATCH function separately to ensure you get a match before wrapping it in HYPERLINK formula.

 

[owendodd]

[Book1.xls]SCHEDULE2!$A$3

No it doesn't seem to be finding its match, it looks like it gets stuck at a empty cell value!

 

[fairwinds]

[Book1.xls]SCHEDULE2!$A$3

No it doesn't seem to be finding its match, it looks like it gets stuck at a empty cell value!

If the formula retutrns such text, you have a match...

 

[owendodd]

The fact that it is not matching correctly match be down to cell formats?