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 rowBut I am not sure how to complete the rest of it?![]()
=VLOOKUP(B2,File!$B$3:$E$158,2,FALSE
Thanks in advance for any assistance!
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 rowBut I am not sure how to complete the rest of it?![]()
=VLOOKUP(B2,File!$B$3:$E$158,2,FALSE
Thanks in advance for any assistance!
Last edited by 00Able; 12-18-2011 at 02:15 PM.
Providing Problems for Your Solutions
STARS are my Punching Bag, You will be rewarded.
In the rare event that I may help you, feel free to make me see STARS
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
Audere est facere
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.
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
Thanks both works great!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks