VBA for Partial Match of name and populate result on another worksheet

[dorchin88]

Good day!

I need to lookup a student name say "Sean" from worksheet 2 "database" columnA name, columnB amount.
The search result on database worksheet should populate on worksheet 1 from A100 cell for name and B100 cell for amount. The search criteria should be on worksheet 1 "lookup" - A1 cell where i can input "Sean"

Would appreciate any help !

Thanks
Dor