Index and match function spanning multiple columns and rows

[L8NightKebab]

Hi im working on 2 sheets and im trying to use the index and match function to match a persons name on a range of columns on another sheet and get the data thats associated with that name, the data is always on the same row number off set by 1 column to the right, I currently use "=INDEX(Sunday!$F$5:$F$16, MATCH(F11, Sunday!$E$5:$E$16, 0))" and can get the data when the users information is in a single array however due to the structure of the spread sheet there are multiple rows and columns

 

[kvsrinivasamurthy]

Try.
=FILTER(Sunday!$F$5:$F$16, Sunday!$E$5:$E$16=F11 )