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
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