Hi Guys,
Quick question that I thought should be pretty straight forward but has stumped me.
Having a data set, lets say for each day of the week, Monday -> Sunday, with random values in each days column.
Is there a function (ive been playing around with the indirect, but haven't been able to get the desired results) that when typed in the week name, such as "Tuesday" will spit out the column of data below the Tuesday header?
I attached a spreadsheet just if my explanation was not clear, let me know what direction would lead to this result
Thanks for any help!
Bookmarks