Creating Links Between Spreadsheets

  • Thread starter Thread starter vvll
  • Start date Start date
V

vvll

Is it possible to create links between spreadsheets based on
“if/then” criteria?

I have an invitation list for a party, and then an attendee list with
a whole different layout/fields for the invitees who respond
“yes”.

Can I create a link from “Invitee” to “RSVP”
list with “if RSVP = ‘yes’ then link to
“Attendee” list?

Any help appreciated

concaf2003
 
Hi wII
Use the HYPERLINK Worksheet Function
Not clear on your question, this should get you started:

=IF(C2="RSVP",HYPERLINK("#RSVP!A1",RSVP!A1),IF(C2="invitee",HYPERLINK("#invitee!A1",invitee!A1),""))

--or--
=IF(C2="RSVP",HYPERLINK("#RSVP!A1","[link]"),IF(C2="invitee",HYPERLINK("#invitee!A1","[link]i"),""))

Please don't post with open and closed double quotes, they do
not come through very well. Just use the double-quote that
is on the keyboard for both.
 
Back
Top