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 )

 

[L8NightKebab]

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

Sorry for the late reply, I found a fix:

=IFERROR(INDEX(SUNDAY!$E$5:$E$67,MATCH($F5,SUNDAY!$D$5:$D$67,0)),IFERROR(INDEX(SUNDAY!$H$5:$H$61,MATCH($F5,SUNDAY!$G$5:$G$61,0)),0))

I'm sure there is a more efficient way to do this but I just created a if error statement and did 2 seperate index match functions