I'm working on a database right now for our school, similar to a directory. What I want to do is be able to look up what items a staff member has been issued and when/if they were returned. What I have right now is one sheet with all the information about the staff that looks like the one below. I want to create a separate sheet where you could look up a staff member by last name and can find all the information in the array relative the the specific cell looked up.
<tbody>
</tbody>
So, on the "lookup" sheet, I want to be able to input either Doe and have the look up return cells B2:E6, or if I input Smith it should return cells B7:D11.
I've been experimenting with Vlookup, hlookup, index, and match but haven't been able to get exactly what I want. Any help would be much appreciated.
Last Name | First Name | Position | Building | Items |
Doe | Jane | Principal | High School | Cell Phone |
ID Badge | ||||
Keys | ||||
Radio | ||||
Smith | John | HR Director | Admin Ctr. | Cell Phone |
ID Badge | ||||
iPad | ||||
Keys | ||||
Projector |
<tbody>
</tbody>
So, on the "lookup" sheet, I want to be able to input either Doe and have the look up return cells B2:E6, or if I input Smith it should return cells B7:D11.
I've been experimenting with Vlookup, hlookup, index, and match but haven't been able to get exactly what I want. Any help would be much appreciated.