INDEX MATCH formula

[cyrous0425]

Hi guys! I have a excel sheet like this https://imgur.com/a/NlFCgbO and I want to pull some specific data by day. Like for example if I select 1 it will look like this https://imgur.com/a/BIEyiyP. Thanks!

 

[Special-K99]

Re: INDEX MATCH formula need help?

in CREW 1!B8
=IFERROR(INDEX(PRINTING!C$12:C$18,AGGREGATE(15,6,ROW(C$12:C$18)/('CREW 1'!C$12:C$18=),ROWS(C$12:C12)),COLUMN()-1),"")

copy down for as many rows as you have data for on CREW 1 and across to column E

 

[cyrous0425]

Re: INDEX MATCH formula need help?

Thanks for the reply. Unfortunately I'm off now in the office. I will try it tomorrow and will let you know next. Thanks

 

[cyrous0425]

Re: INDEX MATCH formula need help?

Good day sir. I just tried the formula you provided and it gives me an error. Please see this https://imgur.com/a/LcBr4EC. Thanks

 

[Special-K99]

Re: INDEX MATCH formula need help?

Hi

My mistake, it should be this

=IFERROR(INDEX(PRINTING!$C$12:$C$18,AGGREGATE(15,6,ROW(C$12:C$18)/('CREW 1'!$C$12:$C$18=PRINTING!$C$5),ROWS(C$12:C12)),COLUMN()-1),"")

where PRINTING!C5 contains the day number