Help with Formula PLEASE

[DanielHaynes]

Hey Guys,

First time here and hoping someone could Help me:

=INDEX($G$4:$G$416,SMALL(IF($E$4:$E$416=(VLOOKUP(TODAY(),SUMMARY,26,FALSE)),ROW($G$4:$G$416)-ROW($G$4)+1),COLUMNS('DATA@'!$DQ$6:DQ6)))

I am a Youtube and google Excel user (No REAL Knowledge) and i have come up with this formula which really works well for me. However, i want to add 1 more condition and that is where i am stumped.

I want it to Only Give me back infomation if Row F has "Monday" in it.

So something like:

=if($f$4:$f$416= "Monday",INDEX($G$4:$G$416,SMALL(IF($E$4:$E$416=(VLOOKUP(TODAY(),SUMMARY,26,FALSE)),ROW($G$4:$G$416)-ROW($G$4)+1),COLUMNS('DATA@'!$DQ$6:DQ6)))

But that doesn't work.
Can someone PLEASE HELP. GOOGLE HAS FAILED ME!

I am happy to change the way i been trying to do. My Formula will give me the answers for all data, but not specific data. See attached

Thanks,

Daniel

[BadlySpelledBuoy]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

http://www.excelforum.com/excel-gene...e-it-goes.html

Thread Closed.