excel if function with date

i have two sheets(sheet1 & sheet2),Likewise Sheet1 A B C H C-1 Hall-1 ok 30-04-2018 c-2 Hall-2 ok c-3 Hall-3 ok

Sheet2 A B C 29-04-2018 Hall-1 ok 29-04-2018 Hall-2 ok 29-04-2018 Hall-3 ok 30-04-2018 Hall-1 ok 30-04-2018 Hall-2 ok 30-04-2018 Hall-3 ok 01-05-2018 Hall-1 ok 01-05-2018 Hall-2 ok 01-05-2018 Hall-3 ok

Sheet1 H1 cell value will change on daily basis, based on that value i want formula result.i tried it, but result not came, so please find the erroed formula and give your suggestion.

=IF($H$1=Sheet2!$B$4:$B$500,(VLOOKUP(Sheet1!$B7,Sheet2!$B$2:$C$500,2,FALSE)))

Regards Shcsam