| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Value a cell based on vlookup results | Excel Worksheet Functions | |||
| Jump to cell based on cell results created by calendar control too | Excel Discussion (Misc queries) | |||
| Making a Cell turn color based on results in another cell | Excel Discussion (Misc queries) | |||
| =If() results based on cell color? | Excel Worksheet Functions | |||
| How do I annotate the cell results from Excel to a Hyperlink? | Excel Discussion (Misc queries) | |||
Threaded Mode
