If Then Excel Formula

[richmcgill]

I need help with a formula

Tab 1
Cell a1 with a manually entered date

Tab 2
Column A Column B
Loan # Dollar Amount

Tab 3
Column A Column B
Loan # Date

If the date in tab 3 matches the date on tab 1
and Loan Number both tab 2 & 3 match

Show me the loan # and the Dollar Amount on tab 4

I need a formula other than a vlookup or pivot table.

I was trying to use index with match but I could not get it to work.

Thank you!

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/excel-questions/1102834-list-accounts-if-match-date.html

Please do not post the same question multiple times. All clarifications, directly-related follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html).