Here is what I have. A Calendar with multiple cells per each date. what I am looking for is to present my data on a home row. without having to scroll each time to look for my data. I have already a cell presenting todays date at all times so when it changes the data will change accordingly. so I have a simple 1 month calendar, on top row says month and year, next row all the days(sun-sat) then each day has 2 col. of 5 rows. cell (1,1) has the date which is formatted as a special number "d" to put day from m/d/yyyy in that cell. all other cells are currently manual entry which I would like to pull the data from. I figured that I want something to the effect of Index and Match Function but not sure how it would be written. so in a sense I want to lookup the day then lookup the data within that day. sorry for not displaying anything, but the site wont let me go to next line