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