Search Function that gives off Entire Column of Data

[b0ttle]

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!

[gak67]

The OFFSET function wont "spit out" the column but it can be used as a column range within another function. Try this in Q8 of your sample, and copied/dragged down:

Please Login or Register  to view this content.

[b0ttle]

Awesome, seems to work out pretty good

Thanks for all of your help!