how to write if function to assign values to multiple cells not only one

Hi everybody

I,m new here

my problem is as follows:

I have Two excel sheets

first sheet :has employees data with (id,name,job,department)
second sheet :is a form which has
1- three textboxes (name ,job,department)
2-a label filled with the id of an employee

what I want is to write if function to compare the id from the two sheets and when it is the same id ...I want the name ,job,department to be filled from the first sheet to the text boxes in the second sheet.


more explanation:I want the if function to do multiple missions (to fill many cells with their values at once )

so can I do this with if function and how ??

I really appreciate any help cause I really need this in my new work


thaxx in advance