I'm having great difficulty here with something I suspect is very easy to achieve. I've attached a screenshot of my worksheet entitled astrology.
On row 53, there are 24 divisions of 360. At any single time, 23 of the cells will return false and 1 will be true. The cell that is true changes from day to day depending upon the position of the moon.
What I need is to place the number in row 38 that is in the same column as where the true (1) is located on row 53, into cell A40.
So in this example, the true (1) on row 53 is in column D, which correlates with the number 30 on row 38 on column D.
I cannot use an if function because there are more than 7 ifs... as there are 24 divisions of 15 degrees within the 360 circle.
I dont know how to use offset function as the true cell changes every day, so therefore I cannot use offset -15 rows as there is no fixed cell that I can reference from as the true cell could be anyone of B53 - Y53.
I'm pulling what hair I have left over this and will be most grateful if anybody can show me the way forward.
Bookmarks