Is there an easier way to do call up info then using a ton of nested IF functions?

Here are the two sheets in question

Instructions

DATABASE

So, here is what I'm trying to do. On the Instructions sheet, there is a drop down box that has all of the departments from the DATABASE sheet. You just select what dept a new a worker will be working in. What I would like to do is make it so that when you select a department from the drop down box, excel will fill in the rest of the information (phone number, address, manager and assistant mgr) using the corresponding info from the database.

I know that I could do this with nested IF functions, you know for the Manager field, like:

=IF(B2=DATABASE!F4, A4, IF(B2=DATABASE!F5, A5, IF(B2=DATABASE!F6, A6, IF(B2=DATABASE!F7, A7...)))))))))

And that's just the manager one. I'd need a similar thing for the asst mgr, address, phone number and other stuff.

I know I could do that and it would work. But I would also need to add an additional IF statement to the end every time I add another department to the database. I was hoping that there was an easier way to do this.

EDIT: Ugh... I spelled "than" wrong. Probably because I had been writing "IF" so much...

Seems like this could be done with Index/Match. Would be easier to tell for sure if you would attach a sample workbook.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window (or use the paperclip icon).

Glad it worked okay. The 'INDEX' function returns the value from the range specified at the row given. The row is found by matching the Department name to Departments in column F of your database. The 'IFERROR' just hides the N/A errors that show up if there's no match, which there won't be if the drop down in C7 is left with '---'.

Hope this makes some sense. Thanks for the Rep mark.
DBY