Conditional "If Statement" Help

[malawimick]

Help with conditional "If Statement"
There are 2 worksheets "Selections" and "Member Payments"
I am trying to achieve the following without success:-
if "Selections!B2>0" and "Selections!A2= "7/1/12" then "Member Payments!A2" should = "Selections!B2" ($2) ...and so on
Having trouble making reference to dates

[adaws]

In Member Payments!A2 use this formula...
=if(and(Selections!B2>0,Selections!A2= Member Payments!A1),Selections!B2,FALSE)

[Haseeb Avarakkan]

Looks like VLOOKUP should do it. Try this A2, copy across & down.

=VLOOKUP(A$1+0,Table2,2,0)

If your looking to extract all the information related to a date. use this in A2,

=IFERROR(INDEX(Selections!$B:$B,SMALL(IF(Table2[Date]=A$1+0,ROW(Table2[Date])),ROWS(A$2:A2))),"")

Confirmed with CTRL+SHIFT+ENTER rather than just ENTER, then copy down & across

[malawimick]

Sorry Haseeb - I have not marked as solved yet as I was busy yesterday.
Hope to resolve today