hyperlink from on cell to another worksheet cell

[Guest]

I am trying to see if it is possible to put a hyperlink on a cell and due a match statement to compare the text in one cell and hyperlink to another spreadsheet where that text is located.

All I can find is locating to specific cells and the list I am trying to link has over 700 cells to link and would like to do it in a formula without a macro if possible.

Any ideas?

 

[Peo Sjoblom]

You can link to another workbook using index and match

=INDEX('C:\Documents and Settings\Peo Sjoblom\My Documents\[Dinner
Planners.xls]Weekly Meal Planner'!$10:$10,MATCH(D1,'C:\Documents and
Settings\Peo Sjoblom\My Documents\[Dinner Planners.xls]Weekly Meal
Planner'!$9:$9,0))

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

I am trying to see if it is possible to put a hyperlink on a cell and due

a match statement to compare the text in one cell and hyperlink to another
spreadsheet where that text is located.

All I can find is locating to specific cells and the list I am trying to

link has over 700 cells to link and would like to do it in a formula without
a macro if possible.

 

[Nimit Mehta]

You can use IF function to compare and then give you true
or false or do another function if true and another if
false.


=IF('D:\CONFERENCE\CONFERENCE\[BAMKIM MEHTA.xls]Sheet1'!
$J$4='D:\CONFERENCE\CONFERENCE\[ANJANI PARIKH.xls]Sheet1'!
$J$4,"TRUE","FALSE")

-Nimit

-----Original Message-----
You can link to another workbook using index and match

=INDEX('C:\Documents and Settings\Peo Sjoblom\My Documents\[Dinner
Planners.xls]Weekly Meal Planner'!$10:$10,MATCH (D1,'C:\Documents and
Settings\Peo Sjoblom\My Documents\[Dinner Planners.xls] Weekly Meal
Planner'!$9:$9,0))

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

I am trying to see if it is possible to put a hyperlink

on a cell and due
a match statement to compare the text in one cell and hyperlink to another
spreadsheet where that text is located.

All I can find is locating to specific cells and the

list I am trying to
link has over 700 cells to link and would like to do it in a formula without
a macro if possible.

Any ideas?

.