Matching data in 2 worksheets & populating another cell

[AMorgan]

I have 2 worksheets. In worksheet 2, if D2 equals an employee number in column H in worksheet 1, then I want to populate cell P2 in worksheet 2 with the matched file no. located in column I from worksheet 1. That is, column H has the employee number and column I has the file no. belonging to that employee. Hope this makes sense!

 

[JoeMo]

Try this (change ranges H & I to suit) in Sheet2 cell P2:

=IF(ISNA(MATCH(D2,Sheet1!H2:H50,0)),"",INDEX(Sheet1!I2:I50,MATCH(D2,Sheet1!H2:H50,0)))

 

[AMorgan]

Thanks for that, however, doesn't seem to work. I changed the formula to:
=IF(ISNA(MATCH(D14,Sheet1!$H$2:$H$23250,0)),"",INDEX(Sheet1!$I$2:$I$23250,MATCH(D14,Sheet1!$H$2:$H$23250,0)))
Did I do something wrong in changing it?
I'll try and explain what I'm trying to do a bit better: I have column H in worksheet 1 where I have a list of employee numbers. In column I in worksheet 1, I have a list of file numbers that correspond to that employee. In another worksheet, I have employee numbers in column D. I want to match the employee number in worksheet 1 with the same employee number in worksheet 2 and populate the cells in P2 (worksheet 2) with the file number that matches the employee number from worksheet 1.
Hope this makes better sense!

 

[JoeMo]

Your formula is fine assuming it is entered in cell P14 of Sheet2. Recognize that it is set to return a blank cell if no match to the value in cell D14 on sheet2 is found in Column H of sheet1. The formula works fine for me.