V Lookup/Hlookup index/match

[00Able]

I want to fill out a section of of cells based on the Day entered in Cell B1, I was able to use vlookup to get one row

Please Login or Register  to view this content.

But I am not sure how to complete the rest of it?

Thanks in advance for any assistance!

[daddylonglegs]

Try this formula in C5

=INDEX(File!D$3:D$158,MATCH(B$2,File!$B$3:$B$158,0)+ROWS(C$5:C5)-1)

copy across to D5 and then both formulas down to row 10

[Haseeb Avarakkan]

If your days are grouped together try this, B5 copy down.

=IF(ROWS(B$5:B5)<=COUNTIF(File!$B:$B,$B$2),INDEX(File!C:C,MATCH($B$2,File!$B:$B,0)+ROWS(B$5:B5)-1),"")

If days are not grouped, B5,

=IFERROR(INDEX(File!C:C,SMALL(IF(File!$B$3:$B$158=$B$2,ROW(File!$B$3:$B$158)),ROWS(B$5:B5))),"")

Confirmed with CTRL+SHIFT+ENTER. copy down.

[00Able]

Thanks both works great!