• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA Lookup or Formula

Bomino

Bomino

Member
Hello,
In attached file I have a some students records in a table. I would like to have a VBA code or formula that will allow me to look up students assignment due time. The desired output is shown in the tab "Summary".
Could someone please help with this matter?

Regards.
 

Attachments

  • Book1.xlsx
    13.1 KB · Views: 5
Bomino

You have to make sure your dates at the same in each sheet. They currently are not.

=IFERROR(INDEX(Data!$C$2:$C$8,MATCH(1,INDEX((Data!$A$2:$A$8=D$3)*(Data!$B$2:$B$8=$C4),),)),"")

I included a second table with the dates set out correctly.

Take care

Smallman
 

Attachments

  • Copy of Book1.xlsx
    12.4 KB · Views: 6
You must log in or register to reply here.
Back
Top