Thread: hyperlink to cell based on formula results
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nba nba is offline
external usenet poster
  
Posts: 11
Default hyperlink to cell based on formula results
I am using a formula to set conditional formatting to display bookings on a
calender. I want to hyperlink from the calender sheet to the sheet that has
the data. My formula is

=SUM(SUMPRODUCT((Booking_Unit="r3")*(Arrival_Date= L$4)*(Nights0))+SUMPRODUCT((Booking_Unit="r3")*(A rrival_Date<L$4)*(Departure_DateL$4)*(Nights0))+ SUMPRODUCT((Booking_Unit="r3")*(Departure_Date=L$4 )*(Nights0)))

This formula gives a result of 1 or 2.

Can you hyperlink to a cell reference using a formula result?
Reply With QuoteReply With Quote