The sample excel enclosed contains formulas for calculation of Ascendant at 9:00 AM current date at a specific time zone / latitude / longitude.
However, I need to calculate in just reverse way. I mean at what time, the ascendant will be 0 degree / 30 degree / 60 degree...etc. (for same date)
So, the Ascendant values every minute using same formula.(in Data sheet)
However, in Result sheet I have 2 problems still needing some help from experts.
1. With LOOKUP function used in Result! C5 & C11, it stuck at the end of range..i. e. at 360...I wish...it should consider AG3-AH3 range again after AG14-AH14...
2. With VLOOKUP function in C6 & C12, it should show the 'Time' where the nearest value in DATA!V matches with Result!C5 , C11
Can someone suggest the correct formulas please ?
Thanking in advance.
However, I need to calculate in just reverse way. I mean at what time, the ascendant will be 0 degree / 30 degree / 60 degree...etc. (for same date)
So, the Ascendant values every minute using same formula.(in Data sheet)
However, in Result sheet I have 2 problems still needing some help from experts.
1. With LOOKUP function used in Result! C5 & C11, it stuck at the end of range..i. e. at 360...I wish...it should consider AG3-AH3 range again after AG14-AH14...
2. With VLOOKUP function in C6 & C12, it should show the 'Time' where the nearest value in DATA!V matches with Result!C5 , C11
Can someone suggest the correct formulas please ?
Thanking in advance.